Structure Access

📄️ CREATE INDEX

CREATE INDEX ( aTable ; fieldsArray ; indexType ; indexName {; *} )

DELETE INDEX ( fieldPtr | indexName {; *} )

EXPORT STRUCTURE ( exportedStructure {; format} )

Field ( tableNum ; fieldNum ) -> fieldPtr

Field name ( fieldPtr | tableNum {; fieldNum} ) : Text

Get external data path ( aField ) : Text

GET FIELD ENTRY PROPERTIES ( fieldPtr|tableNum {; fieldNum}; list ; mandatory ; nonEnterable ; nonModifiable )

GET FIELD PROPERTIES ( fieldPtr | tableNum {; fieldNum}; fieldType {; fieldLength {; indexed {; unique {; invisible}}}} )

GET MISSING TABLE NAMES ( missingTables )

GET RELATION PROPERTIES ( fieldPtr|tableNum {; fieldNum}; oneTable ; oneField {; choiceField {; autoOne {; autoMany}}} )

GET TABLE PROPERTIES ( tablePtr|tableNum ; invisible {; trigSaveNew {; trigSaveRec {; trigDelRec {; trigLoadRec}}}} )

IMPORT STRUCTURE ( xmlStructure )

Is field number valid ( tableNum | tablePtr ; fieldNum ) : Boolean

Is table number valid ( tableNum ) : Boolean

Last field number ( tableNum | tablePtr ) : Integer

Last table number : Integer

PAUSE INDEXES ( aTable )

REGENERATE MISSING TABLE ( tableName )

RELOAD EXTERNAL DATA ( aField )

RESUME INDEXES ( aTable {; *} )

SET EXTERNAL DATA PATH ( aField ; path )

SET INDEX ( aField ; index {; *} )

Table ( tableNum | aPtr ) : any

Table name ( tableNum | tablePtr ) : Text