DbCreateIndex()
Creates an index file in a work area.
DbCreateIndex( <cIndexFile>, <cIndexKey>, [<bIndexKey>], [<lUnique>] ) --> NIL
DbROrdName()
Determines the index tag of a child work area.
DbROrdName( <nRelation> | <cRelName> ) --> cTagName
DbSeek()
Positions the record pointer to a record based on the value of an index expression
DbSeek( <IndexKeyValue>, [<lSoftSeek>], [<nIndex>|<cTagName>], [<lLast>] ) --> lFound
DELETE TAG
Removes an index from a compound index file
DELETE TAG <cTagName> [OF <cIndexFile>] [, <cTagName> [OF <cIndexFile>]] DELETE TAG <cTagName> [IN <cIndexFile>] [, <cTagName> [IN <cIndexFile>]]
Descend()
Gives an inverted index key value for sorting in descending order.
Descend( <Expression> [,<lCompatible>] ) --> DescendValue
INDEX
Creates an index file.
INDEX ON <IndexKey> [TAG <cTagName>] TO <cIndexFile> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [EVAL <bBlock> [EVERY <nStep>] ] [REST] [ALL] [UNIQUE] [ASCENDING | DESCENDING] [ADDITIVE] [CANDIDATE] [SUBINDEX] [CUSTOM] Or for index files with multiple indexes: INDEX ON <IndexKey> TAG <cTagName> [TO <cIndexFile>] [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [EVAL <lExpression> [EVERY <nStep>] ] [REST] [ALL] [UNIQUE] [ASCENDING | DESCENDING] [ADDITIVE] [CANDIDATE] [SUBINDEX] [CUSTOM]
IndexOrd()
Returns the ordinal position of the controlling index in a work area.
IndexOrd() --> nOrder
OrdBagName()
Returns the filename of the file containing an index.
OrdBagName( <nIndex> | <cTagName>, [<nInfo>] ) --> cIndexFile
OrdCondSet()
Sets the conditions used to create indexes with OrdCreate().
OrdCondSet( [<cForCondition>], [<bForCondition>], [<lAllRecords>], [<bWhileCondition>], [<bOption>], [<nStep>], [<xnRecNo>], [<nNext>], [<xnRecord>], [<lRest>], [<lDescend>], [<lCandidate>], [<lSubIndex>], [<lCustom>] ) --> NIL
OrdCreate()
Creates an index in an index file.
OrdCreate( <cIndexFile>, [<cTagName>], <cIndexKey>, [<bIndexKey>], [<lUnique>], [<lAdditive>] ) --> NIL
OrdInfo()
Sets or returns information about an order/index
OrdInfo( <nDefine>, [<xNewSetting>] ) --> xOldSetting
OrdIsCandidate()
Checks if an order is an candidate order
OrdIsCandidate([<cTagName>|<nIndex>]) -> lCandidate
OrdIsSubIndex()
Checks if a order is a SubIndex order
OrdIsSubIndex([<cTagName>|<nIndex>]) -> lSubIndex
OrdKeyNo()
Determines the relative logical record number of the current data record within the indexed database.
OrdKeyNo( [<nIndex> | <cTagName>] ) --> nRelativeRecord
OrdKeyRemove()
Manually remove key value from a custom order
OrdKeyRemove([<cTagName>|<nIndex>]) -> lSuccess
OrdList()
Determines a list of all tag names relating to the current work area.
OrdList() --> aTagNames
OrdListAdd()
Activate one or more indexes in a work area.
OrdListAdd( <cIndexFile> [,<cTagName>] ) --> NIL
OrdNumber()
Returns the position of an index in the index list based on the index name.
OrdNumber( [<cTagName>] ) --> nIndexOrder
OrdSetCustom()
Transforms an existing order to a custom order for manual key manipulation
OrdSetCustom([lSet]) -> lCustom
OrdSetFocus()
Sets the controlling index in a work area.
OrdSetFocus( [<cTagName>|<nIndex>] ) --> cLastIndexName
OrdWildSeek()
Search for a single or subset of records matching a specific wildcard pattern.
OrdWildSeek( <cSkeletonExpr> ) --> lMatch OrdWildSeek() -> nRecord
SEEK
Positions the record pointer based on the value of an index expression.
SEEK [LAST] <Expression> ORDER [TAG] <cTagName>|<nIndex> [IN <nWorkArea> | <cAlias> ] [SOFTSEEK]
SET INDEX
Opens one or more index files in the current work area.
SET INDEX TO [<cIndexFiles,...>] [ORDER [TAG] <nIndex> | <cTagName> [ASCENDING | descending] [ADDITIVE]
SET ORDER
Specifies the controlling index in the current work area or the work area specified.
SET ORDER TO [<nIndex>] | TAG <cTagName> [OF <cIndexfile>] [IN <nWorkArea> | <cAlias> ] [ASCENDING | descending]
SET UNIQUE
Sets whether an index may contain multiple records with the same key value.
SET UNIQUE on | OFF | <lToggle>