Home > Class Reference > ENSLIB namespace > %FileMan.Field

%FileMan.Field

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.

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: FILECheck(), FILEDelete(), 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()

Inherited Methods

%AddToSaveSet() %GUID() %OriginalNamespace()
%AddToSyncSet() %GUIDSet() %PackageName()
%CheckConstraints() %GetLock() %PurgeIndices()
%CheckConstraintsForExtent() %GetParameter() %Reload()
%ClassIsLatestVersion() %GetSwizzleObject() %RemoveFromSaveSet()
%ClassName() %Id() %ResolveConcurrencyConflict()
%ComposeOid() %IsA() %RollBack()
%ConstructClone() %IsModified() %Save()
%Delete() %IsNull() %SaveDirect()
%DeleteExtent() %KillExtent() %SerializeObject()
%DeleteId() %LockExtent() %SetModified()
%DispatchClassMethod() %LockId() %SortBegin()
%DispatchGetModified() %New() %SortEnd()
%DispatchGetProperty() %NormalizeObject() %SyncObjectIn()
%DispatchMethod() %ObjectIsNull() %SyncTransport()
%DispatchSetModified() %ObjectModified() %UnlockExtent()
%DispatchSetMultidimProperty() %Oid() %UnlockId()
%DispatchSetProperty() %OnBeforeAddToSync() %ValidateIndices()
%Exists() %OnDetermineClass() %ValidateObject()
%ExistsId() %Open()
%Extends() %OpenId()

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
query AllFieldsByName(file As %Library.String)
SQL Query:
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()

Storage

Storage Model: CacheSQLStorage

Maps: 1