Commands and Topics for Structure Information
Structure Information, Introduction
OP Count tables
(connectionID; numOfTables)
Longint
OP Get all tablenames
(connectionID; tableNames)
Longint
OP Get field properties
(connectionID; tableID; tableInvisible; fieldNames; fieldTypes; fieldLengths; fieldIndexed; fieldInvisible)
Longint
OP Get table properties
(connectionID; tableID; tableInvisible; tableLeft; tableTop; tableRight; tableBottom; fieldNames; fieldTypes; fieldLength; fieldIndexed; fieldUnique; fieldInvisible; fieldEnterable; fieldModifiable; fieldMandatory; fieldRelatedTable; fieldRelatedField; fieldRelatedWild; fieldManyToOne; fieldOneToMany; fieldDelControl; fieldWhatControl; fieldAutoAssign)
Longint
OP Get one field number
(connectionID; tableField; tableID; fieldID)
Longint
OP Get all field numbers
(connectionID; tableFields; tableIDs; fieldIDs)
Longint
OP Get one tablename
(connectionID; tableID; nameOfTable)
Longint
OP Count fields
(connectionID; tableID; nbOfFields)
Longint
OP Cache structure
(connectionID; cacheStructure)
Longint