%FileMan.Field
deprecated persistent class %FileMan.Field extends %Library.Persistent
SQL Table Name: %FileMan.Field
This file stores the descriptive information for all fields in a file for a FileMan managed database.Note: The FileMan toolset is available and fully supported in InterSystems IRIS for existing FileMan users. InterSystems recommends against starting new development projects using FileMan.
Property Inventory
Parameters
parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
Properties
property CHARACTERISTICS as %String;
Property methods: CHARACTERISTICSDisplayToLogical(), CHARACTERISTICSGet(), CHARACTERISTICSIsValid(), CHARACTERISTICSLogicalToDisplay(), CHARACTERISTICSLogicalToOdbc(), CHARACTERISTICSNormalize(), CHARACTERISTICSSet()
property DESCRIPTION as list of %String;
Property methods: DESCRIPTIONBuildValueArray(), DESCRIPTIONCollectionToDisplay(), DESCRIPTIONCollectionToOdbc(), DESCRIPTIONDisplayToCollection(), DESCRIPTIONDisplayToLogical(), DESCRIPTIONGet(), DESCRIPTIONGetObject(), DESCRIPTIONGetObjectId(), DESCRIPTIONGetSwizzled(), DESCRIPTIONIsValid(), DESCRIPTIONLogicalToDisplay(), DESCRIPTIONLogicalToOdbc(), DESCRIPTIONNormalize(), DESCRIPTIONOdbcToCollection(), DESCRIPTIONSet(), DESCRIPTIONSetObject(), DESCRIPTIONSetObjectId()
relationship FILE as %FileMan.File [ Required , Inverse = FIELDS , Cardinality = parent ];
Property methods: FILEGet(), FILEGetObject(), FILEGetObjectId(), FILEGetSwizzled(), FILEIsValid(), FILENewObject(), FILEOnDelete(), FILERClose(), FILERExec(), FILERFetch(), FILERelate(), FILESQLCompute(), FILESet(), FILESetObject(), FILESetObjectId(), FILEUnRelate(), FILEUnSwizzle()
property NAME as %String;
Property methods: NAMEDisplayToLogical(), NAMEGet(), NAMEIsValid(), NAMELogicalToDisplay(), NAMELogicalToOdbc(), NAMENormalize(), NAMESet()
property NUMBER as %Numeric [ Required ];
Property methods: NUMBERDisplayToLogical(), NUMBERGet(), NUMBERIsValid(), NUMBERLogicalToDisplay(), NUMBERNormalize(), NUMBERSet()
Queries
query AllFields(file As %Library.String)
SQL Query:
SELECT NUMBER,NAME FROM %FileMan.Field WHERE "FILE" = :file OR :file IS NULL ORDER BY NUMBER
SELECT NUMBER,NAME FROM %FileMan.Field WHERE "FILE" = :file OR :file IS NULL ORDER BY NUMBER
query AllFieldsByName(file As %Library.String)
SQL Query:
SELECT NUMBER,NAME FROM %FileMan.Field WHERE "FILE" = :file OR :file IS NULL ORDER BY NAME
SELECT NUMBER,NAME FROM %FileMan.Field WHERE "FILE" = :file OR :file IS NULL ORDER BY NAME
Indexes
index (IdKey on NUMBER) [IdKey, PrimaryKey, Type = key, Unique];
Index methods: IdKeyCheck(), IdKeyDelete(), IdKeyExists(), IdKeyOpen(), IdKeySQLCheckUnique(), IdKeySQLExists(), IdKeySQLFindPKeyByConstraint(), IdKeySQLFindRowIDByConstraint()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BuildDeferredIndices()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
Storage
Storage Model: SQLStorage
Maps: 1
Map number 1 is named Master
thismap.Global: ^DD
^DD({%FileMan.File.NUMBER},{NUMBER})
|
= |
|