persistent class %FileMan.Field
extends %Persistent
This file stores the descriptive information for all fields in a file for a FileMan managed database.
parameter READONLY = 1;
READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
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
index (IdKey on NUMBER) [IdKey,PrimaryKey,Unique];