Skip to main content
Version: 20 R7

Structure Access

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

EXPORT STRUCTURE ( exportedStructure {; format} )
Field ( tableNum ; fieldNum ) -> fieldPtr  
Field ( fieldPtr ) -> fieldNum

Field name ( fieldPtr ) : Text
Field name ( tableNum ; fieldNum ) : Text

Get external data path ( aField ) : Text
GET FIELD ENTRY PROPERTIES ( fieldPtr ; list ; mandatory ; nonEnterable ; nonModifiable )
GET FIELD ENTRY PROPERTIES ( tableNum ; fieldNum ; list ; mandatory ; nonEnterable ; nonModifiable )

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

GET MISSING TABLE NAMES ( missingTables )
GET RELATION PROPERTIES ( fieldPtr ; oneTable ; oneField {; choiceField {; autoOne {; autoMany}}} )
GET RELATION PROPERTIES ( tableNum ; fieldNum ; oneTable ; oneField {; choiceField {; autoOne {; autoMany}}} )

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

IMPORT STRUCTURE ( xmlStructure )
Is field number valid ( tablePtr ; fieldNum ) : Boolean
Is field number valid ( tableNum ; fieldNum ) : Boolean

Is table number valid ( tableNum ) : Boolean
Last field number ( tableNum ) : Integer
Last field number ( 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 ) : Pointer
Table ( tablePtr ) : Integer
Table ( fieldPtr ) : Integer

Table name ( tableNum ) : Text
Table name ( tablePtr ) : Text