DbFilter()
Returns the filter condition currently set for a work area.
DbFilter() --> cFilterExpression
DbGoPosition()
Moves the record pointer to a percent position in a work area
DbGoPosition( <nPercent> ) --> 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
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
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
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
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 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 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>]