Group Table / Index Navigation
Bof()
Determine whether the beginning of the file was reached.
Bof() --> lBof
CONTINUE
Continues the execution of the last LOCATE command.
CONTINUE
DbClearFilter()
Clears the filter setting in a work area.
DbClearFilter() --> NIL
DbClearRelation()
Clears all current relations in a work area.
DbClearRelation() --> NIL
DbClearScope()
Clears the top and/or bottom scope
DbClearScope( [<nScope>] ) --> NIL
DbContinue()
Continues a sequential search defined by DbLocate().
DbContinue() --> lFound
DbDescend()
Checks if the order for navigation is descending
DbDescend() --> lNavIsDescend
DbFilter()
Returns the filter condition currently set for a work area.
DbFilter() --> cFilterExpression
DbGoBottom()
Sets the record pointer to the last logical record.
DbGoBottom() --> NIL
DbGoPosition()
Moves the record pointer to a percent position in a work area
DbGoPosition( <nPercent> ) --> NIL
DbGoto()
Positions the record pointer to a specific record.
DbGoto( <xRecordID> ) --> NIL
DbGoTop()
Sets the record pointer to the first logical record.
DbGoTop() --> NIL
DbLocate()
Defines a condition for a sequential search and performs the search.
DbLocate( <bForCondition>, [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>] ) --> lFound
DbPosition()
Returns the position of the record pointer as a percent value
DbPosition() --> nPercent
DbScope()
Checks if a scope is set in a work area.
DbScope( [<nScope>] ) --> xScope | aScopeBoth | lIsScope
DbSeek()
Positions the record pointer to a record based on the value of an index expression
DbSeek( <IndexKeyValue>, [<lSoftSeek>], [<nIndex>|<cTagName>], [<lLast>] ) --> lFound
DbSetDescend()
Reverses the navigational order of a work area.
DbSetDescend( <lDescend> ) --> NIL
DbSetFilter()
Sets a filter condition for a work area.
DbSetFilter( <bFilter>, [<cFilter>] ) --> NIL
DbSetFound()
Returns or sets the status of the function Found()
DbSetFound( [<lNewSetting>] ) --> lOldSetting
DbSetOrder()
Sets the controlling index in a work area.
DbSetOrder( <nIndex> ) --> NIL
DbSetRelation()
Creates a relation (link) between two work areas.
DbSetRelation( <nWorkArea> | <cAlias>, <bRelation>, [<cRelation>], [<cTagName>], [<cRelName>], [<lSelective>] ) --> NIL
DbSetScope()
Sets scope values for logical or physical orders.
DbSetScope( <nScope>, <xValue> ) --> NIL
DbSkip()
Positions the record pointer relative to the current record.
DbSkip( [<nRecords>] ) --> NIL
Descend()
Gives an inverted index key value for sorting in descending order.
Descend( <Expression> [,<lCompatible>] ) --> DescendValue
Eof()
Determines whether the end of file was reached.
Eof() --> lEOF
FIND
Finds a character expression in the controlling index.
FIND <cSeekString>
Found()
Determines whether the last search operation was successful.
Found() --> lSuccess
GO
Positions the record pointer to a specific record in the current or in the specified workarea
GO[TO] <xRecordID> | BOTTOM | TOP [IN <nWorkArea> | <cAlias> ]
LastRec()
Returns a value which clearly identifies the last record in a work area.
LastRec() --> xLastRecordID
LOCATE
Defines the condition for a sequential search and performs a search.
LOCATE FOR <lForCondition> [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL]
OrdWildSeek()
Search for a single or subset of records matching a specific wildcard pattern.
OrdWildSeek( <cSkeletonExpr> ) --> lMatch OrdWildSeek() -> nRecord
RecCount()
Returns the number of records in a work area.
RecCount() --> nRecords
RecNo()
Returns a value which clearly identifies the current record.
RecNo() --> xRecordID
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 DELETED
Sets whether records with deletion flags will be visible.
SET DELETED on | OFF | <lToggle>
SET FILTER
Specifies or removes a filter condition for a work area.
SET FILTER TO [<lFilter>] [IN <nWorkArea> | <cAlias> ]
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 OPTIMIZE
Enables/Disables expression optimizer of database-kernel
SET OPTIMIZE ON | off | <lToggle>
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 RELATION
Creates a relational link between two work areas.
SET RELATION TO [<cRelation1> | <xRecordID1> INTO <cAlias1> [TAG <cTag1>] ] [, [TO] <cRelation2> | <xRecordID2> INTO <cAlias2> [TAG <cTag2>]...] [ADDITIVE] [SELECT[IVE]]
SET RUSHMORE
Enables/Disables Rushmore optimizer
SET RUSHMORE ON | off | <lToggle>
SET SCOPE
Sets/clears scope values for logical or physical orders
SET SCOPE TO SET SCOPE TO <xValue> SET SCOPE TO <xTop>, <xBottom> SET SCOPETOP TO SET SCOPETOP TO <xTop> SET SCOPEBOTTOM TO SET SCOPEBOTTOM TO <xBottom> BScope:!EF current work area, current order
SET SMARTFILTER
Enables/Disables smart filtering.
SET SMARTFILTER ON | off | <lToggle>
SET SOFTSEEK
Sets whether searches with the command SEEK will be "relative".
SET SOFTSEEK on | OFF | <lToggle>
SKIP
Positions the record pointer relative to the current record.
SKIP [<nRecords>] [ALIAS <cAlias> | <nWorkArea>] SKIP [<nRecords>] [IN <cAlias> | <nWorkArea>]