Commands and Topics for Structure Access

• Structure Access Commands
• CREATE INDEX (aTable; fieldsArray; indexType; indexName{; *})
• DELETE INDEX (fieldPtr | indexName{; *})
• Field (tableNum | fieldPtr{; fieldNum}) Number | Pointer
• Field name (fieldPtr | tableNum{; fieldNum}) String
• GET FIELD ENTRY PROPERTIES (fieldPtr|tableNum{; fieldNum}; list; mandatory; nonEnterable; nonModifiable)
• GET FIELD PROPERTIES (fieldPtr | tableNum{; fieldNum; fieldType{; fieldLength{; indexed{; unique{; invisible}}}})
• Get last field number (tableNum | tablePtr) Number
• Get last table number Number
• GET RELATION PROPERTIES (fieldPtr|tableNum{; fieldNum; oneTable; oneField{; choiceField{; autoOne{; autoMany}}})
• GET TABLE PROPERTIES (tablePtr|tableNum; invisible{; trigSaveNew{; trigSaveRec{; trigDelRec{; trigLoadRec}}}})
• Is field number valid (tableNum | tablePtr; fieldNum) Boolean
• Is table number valid (tableNum) Boolean
• SET INDEX (aField; index{; mode{; *}})
• Table (tableNum | aPtr) Pointer | Number
• Table name (tableNum | tablePtr) String

  ---

  Other related commands:
• Pointers -- Theme: Language Definition
• ORDER BY ({aTable}{; aField{; > or <{; aField2; > or <2; ...; aFieldN; > or <N}{; *}}}) -- Theme: Queries
• QUERY ({aTable}{; queryArgument{; *}}) -- Theme: Queries
• SET AUTOMATIC RELATIONS (one{; many}) -- Theme: Relations
• SET FIELD RELATION (manyTable | manyField; one; many) -- Theme: Relations