Commands and Topics for Structure Access
Structure Access Commands
Count tables
Number
Count fields
(tableNum | tablePtr)
Number
Table name
(tableNum | tablePtr)
String
Field name
(fieldPtr | tableNum{; fieldNum})
String
Table
(tableNum | aPtr)
Pointer | Number
GET TABLE PROPERTIES
(tablePtr|tableNum; invisible{; trigSaveNew{; trigSaveRec{; trigDelRec{; trigLoadRec}}}})
Field
(tableNum | fieldPtr{; fieldNum})
Number | Pointer
GET FIELD PROPERTIES
(fieldPtr | tableNum{; fieldNum; fieldType{; fieldLength{; indexed{; unique{; invisible}}}})
GET FIELD ENTRY PROPERTIES
(fieldPtr|tableNum{; fieldNum; list{; mandatory{; nonEnterable{; nonModifiable}}})
GET RELATION PROPERTIES
(fieldPtr|tableNum{; fieldNum; oneTable; oneField{; choiceField{; autoOne{; autoMany}}})
SET INDEX
(field; index{; mode{; *}})
Get database parameter
({table; }selector{; stringValue})
Longint
SET DATABASE PARAMETER
({table; }selector; value)
Other related commands:
DISTINCT VALUES
(field; array) --
Theme:
Arrays
Pointers
--
Theme:
Language Definition
ORDER BY
({table}{; field{; > or <{; field2; > or <2; ...; fieldN; > or <N}{; *}}}) --
Theme:
Queries
QUERY
({table}{; queryArgument{; *}}) --
Theme:
Queries
QUERY SELECTION
({table}{; queryArgument{; *}}) --
Theme:
Queries
SET AUTOMATIC RELATIONS
(one{; many}) --
Theme:
Relations
SET FIELD RELATION
(manyTable | manyField; one; many) --
Theme:
Relations