Group Table / Index Navigation

Determine whether the beginning of the file was reached.

Bof() --> lBof

Continues the execution of the last LOCATE command.

CONTINUE

Clears the filter setting in a work area.

DbClearFilter() --> NIL

Clears all current relations in a work area.

DbClearRelation() --> NIL

Clears the top and/or bottom scope

DbClearScope( [<nScope>] ) --> NIL

Continues a sequential search defined by DbLocate().

DbContinue() --> lFound

Checks if the order for navigation is descending

DbDescend() --> lNavIsDescend

Returns the filter condition currently set for a work area.

DbFilter() --> cFilterExpression

Sets the record pointer to the last logical record.

DbGoBottom() --> NIL

Moves the record pointer to a percent position in a work area

DbGoPosition( <nPercent> ) --> NIL

Positions the record pointer to a specific record.

DbGoto( <xRecordID> ) --> NIL

Sets the record pointer to the first logical record.

DbGoTop() --> NIL

Defines a condition for a sequential search and performs the search.

DbLocate( <bForCondition>, [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>] ) --> lFound

Returns the position of the record pointer as a percent value

DbPosition() --> nPercent

Checks if a scope is set in a work area.

DbScope( [<nScope>] ) --> xScope | aScopeBoth | lIsScope

Positions the record pointer to a record based on the value of an index expression

DbSeek( <IndexKeyValue>, [<lSoftSeek>], [<nIndex>|<cTagName>], [<lLast>] ) --> lFound

Reverses the navigational order of a work area.

DbSetDescend( <lDescend> ) --> NIL

Sets a filter condition for a work area.

DbSetFilter( <bFilter>, [<cFilter>] ) --> NIL

Returns or sets the status of the function Found()

DbSetFound( [<lNewSetting>] ) --> lOldSetting

Sets the controlling index in a work area.

DbSetOrder( <nIndex> ) --> NIL

Creates a relation (link) between two work areas.

DbSetRelation( <nWorkArea> | <cAlias>, <bRelation>, [<cRelation>], [<cTagName>], [<cRelName>], [<lSelective>] ) --> NIL

Sets scope values for logical or physical orders.

DbSetScope( <nScope>, <xValue> ) --> NIL

Positions the record pointer relative to the current record.

DbSkip( [<nRecords>] ) --> NIL

Gives an inverted index key value for sorting in descending order.

Descend( <Expression> [,<lCompatible>] ) --> DescendValue

Determines whether the end of file was reached.

Eof() --> lEOF

Finds a character expression in the controlling index.

FIND <cSeekString>

Determines whether the last search operation was successful.

Found() --> lSuccess

Positions the record pointer to a specific record in the current or in the specified workarea

GO[TO] <xRecordID> | BOTTOM | TOP [IN <nWorkArea> | <cAlias> ]

Returns a value which clearly identifies the last record in a work area.

LastRec() --> xLastRecordID

Defines the condition for a sequential search and performs a search.

LOCATE FOR <lForCondition> [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL]

Search for a single or subset of records matching a specific wildcard pattern.

OrdWildSeek( <cSkeletonExpr> ) --> lMatch OrdWildSeek() -> nRecord

Returns the number of records in a work area.

RecCount() --> nRecords

Returns a value which clearly identifies the current record.

RecNo() --> xRecordID

Positions the record pointer based on the value of an index expression.

SEEK [LAST] <Expression> ORDER [TAG] <cTagName>|<nIndex> [IN <nWorkArea> | <cAlias> ] [SOFTSEEK]

Sets whether records with deletion flags will be visible.

SET DELETED on | OFF | <lToggle>

Specifies or removes a filter condition for a work area.

SET FILTER TO [<lFilter>] [IN <nWorkArea> | <cAlias> ]

Opens one or more index files in the current work area.

SET INDEX TO [<cIndexFiles,...>] [ORDER [TAG] <nIndex> | <cTagName> [ASCENDING | descending] [ADDITIVE]

Enables/Disables expression optimizer of database-kernel

SET OPTIMIZE ON | off | <lToggle>

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]

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]]

Enables/Disables Rushmore optimizer

SET RUSHMORE ON | off | <lToggle>

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

Enables/Disables smart filtering.

SET SMARTFILTER ON | off | <lToggle>

Sets whether searches with the command SEEK will be "relative".

SET SOFTSEEK on | OFF | <lToggle>

Positions the record pointer relative to the current record.

SKIP [<nRecords>] [ALIAS <cAlias> | <nWorkArea>] SKIP [<nRecords>] [IN <cAlias> | <nWorkArea>]