Group Data Access

Creates a new record in the current work area or an specified workarea.

APPEND [BLANK] [IN <nWorkArea> | <cAlias> ] [NOMENU]

Imports records from a file into the current work area.

APPEND FROM <cFilename> [FIELDS <cFieldname,...>] [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [ALL] [VIA <cDbe> | SDF | DELIMITED [WITH <cDelimiter>] ]

Calculates the average for numeric expressions in the current work area.

AVERAGE <nExpression,...> TO <VarName,...> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [REST] [ALL]

Determines the number of records matching a condition.

COUNT TO <VarName> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [REST] [ALL]

Class function of the DataObject class.

Creates a new record.

DbAppend( [<nLockMode>] ) --> NIL

Clears all current relations in a work area.

DbClearRelation() --> NIL

Marks record as deleted.

DbDelete() --> NIL

Evaluates a code block for each record in a work area.

DbEval( <bBlock>, [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>] ) --> NIL

Exports data from a work area into a new file.

DbExport( <cFilename>, [<aFieldNames>], [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>], [<cDbeName>], [<aDbeInfo>] ) --> NIL

Imports data from a file into a work area.

DbImport( <cFilename>, [<aFieldnames>], [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>], [<cDbeName>], [<aDbeInfo>] ) --> NIL

Combines records from two work areas and writes the result to a new file.

DbJoin( <cAlias>, <cFilename>, [<aFieldnames>], [<bForCondition>] ) --> NIL

Removes deletion flag for a record (recalls the record).

DbRecall() --> NIL

Returns the linking expression of a relation.

DbRelation( <nRelation> | <cRelName> ) --> cLinkExpression

Returns a list of relation names defined for child work areas.

DbRList() --> aRelationNames

Creates a relation (link) between two work areas.

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

Sorts records from a work area and writes them into a file.

DbSort( <cFilename>, <aFieldnames>, [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>] ) --> lSuccess

Totals data from numeric fields of a work area into a second file.

DbTotal( <cFilename>, <bIndexKey>, [<aFieldnames>], [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>] ) --> NIL

Updates the current work area with data from another work area.

DbUpdate( <cAlias>, <bReplace>, <bIndexKey>, [<lRandom>] ) --> NIL

Marks one or more records for deletion.

DELETE [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL] [IN <nWorkArea> | <cAlias> ] [NOOPTIMIZE]

Deletes one or more records in a table. END

DELETE FROM <cTableName> [WHERE <lExpression>] [VIA (<coSession>)]

Determines whether a record is marked as deleted.

Deleted() --> lDeleted

Outputs records and/or displays them on the screen.

DISPLAY <Expression,...> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [TO FILE <cFilename>] [TO PRINTER] [REST] [ALL] [OFF]

Determines the number of fields in the DBF file open in a work area.

FCount() --> nFieldCount

Determines the value of a field in the current record of a work area.

FieldGet( <nFieldPos> ) --> xValue

Sets or returns the settings for a field.

FieldInfo( <nFieldPos>, <nDefine>, [<xNewSetting>] ) --> xOldValue

Return a field name from a work area.

FieldName( <nPosition> ) --> cFieldName

Returns the position of a field in a work area.

FieldPos( <cFieldName> ) --> nFieldPosition

Copies a value into a field of the current record in a work area.

FieldPut( <nFieldPos>, <Expression> ) --> xAssignedValue

Replaces data in the current record with data in a DataObject.

GATHER NAME <oData> [FIELDS <FieldNameList>] [IN <nWorkArea>|<cAlias>] GATHER NAME <oData> FIELDS EXCEPT <SkeletonList> [IN <nWorkArea>|<cAlias>] GATHER NAME <oData> FIELDS LIKE <SkeletonList> [EXCEPT <SkeletonList>] [IN <nWorkArea>|<cAlias>]

Inserts one or more records into a table.

INSERT INTO <cTableName> [(<cFieldName> [, <cFieldName>, ...])] | VALUES (<Expression> [, <Expression>, ...]) | SELECT <SubSelectExpression> | FROM MEMVAR | FROM ARRAY <aExpression> | FROM OBJECT|NAME <oExpression> [VIA (<coSession>)]

Joins records from two work areas and writes the results into a new file.

JOIN WITH <cAlias> TO <cFilename> [FOR <lCondition>] [FIELDS <cFieldname,...>]

Outputs records and/or displays them on the screen.

LIST <Expression,...> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [TO FILE <cFilename>] [TO PRINTER] [REST] [ALL] [OFF]

Removes the deletion flag for one or more records.

RECALL [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL] [IN <nWorkArea> | <cAlias> ] [NOOPTIMIZE]

Returns a value which clearly identifies the current record.

RecNo() --> xRecordID

Assigns values to field variables.

REPLACE <cFieldname> WITH <Expression> [, <cFieldname> WITH <Expression>... ] [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL]

Copies data from the current record to a DataObject.

SCATTER [FIELDS <FieldNameList] NAME <oData> [IN <nWorkArea>|<cAlias>] [ADDITIVE] SCATTER FIELDS EXCEPT <SkeletonList> NAME <oData> [IN <nWorkArea>|<cAlias>] [ADDITIVE] SCATTER FIELDS LIKE <SkeletonList> [EXCEPT <SkeletonList>] NAME <oData> [IN <nWorkArea>|<cAlias>] [ADDITIVE]

Retrieves data from one or more tables

SELECT [DISTINCT][*|ALL] <ColumnExpression> [AS <cAliasName>] [,...] FROM <SelectSource> [AS <cAliasName>] [,...] [INNER|LEFT [OUTER]|RIGHT [OUTER]|FULL [OUTER]] JOIN <cTableName> ON <JoinExpression> | USING <cFieldName> [, <cFieldName>] ] [WHERE <FilterExpression> | <JoinExpression>] [GROUP BY <Expression> [HAVING <FilterExpression>] [UNION [ALL]|INTERSECT|EXCEPT] <SubSelectExpression>] [ORDER BY <Expression> [ASC|DESC] [, <Expression> [ASC|DESC]]] [LIMIT <nExpression> [OFFSET <nExpression>] [VIA (coSession)] [INTO [CURSOR] <cAlias> |INTO ARRAY <aResult> |INTO OBJECTS <aResult> [CLASS <coClassName>] |EVAL <cbExpression> ] |INTO VALUE <xResult> [INTO TABLE <cResultTableName> [VIA <cResultDbeName>]]

Sets whether records with deletion flags will be visible.

SET DELETED on | OFF | <lToggle>

Determines whether files are opened as SHARED or EXCLUSIVE by default.

SET EXCLUSIVE on | OFF | <lToggle>

Enables/Disables NULL/NIL values for fields

SET NULLVALUE ON | off | <lToggle>

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

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

Copies sorted records to a new file.

SORT TO <cFilename> ON <cFieldname> [ [/A | /D] [/C] ] [, <cFieldname> [ [/A | /D] [/C] ] ... ] [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL] [FIELDS FieldNameList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton] [NOOPTIMIZE]

Calculates sums for numeric expressions in the current work area.

SUM <nExpression,...> TO <VarName,...> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [REST] [ALL]

Sums data from numeric fields of a work area into a second file.

TOTAL ON <IndexKey> FIELDS <cFieldname,...> TO <cFilename> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL]

Updates data in the current work area using data from another work area.

UPDATE FROM <cAlias> ON <cKeyExpr> [RANDOM] REPLACE <cFieldname1> WITH <Expression1> [, <cFieldname2> WITH <Expression2>...]

Updates one or more records in a table. END

UPDATE <cTableName> SET <cFieldName> := <Expression>|<SubSelectExpression> [, ...] | FROM (aData|oData) WHERE <lExpression> [VIA (<coSession>)]