Group Data Access
APPEND BLANK
Creates a new record in the current work area or an specified workarea.
APPEND [BLANK] [IN <nWorkArea> | <cAlias> ] [NOMENU]
APPEND FROM
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>] ]
AVERAGE
Calculates the average for numeric expressions in the current work area.
AVERAGE <nExpression,...> TO <VarName,...> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [REST] [ALL]
COUNT
Determines the number of records matching a condition.
COUNT TO <VarName> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [REST] [ALL]
DataObject()
Class
Class function of the DataObject class.
DbAppend()
Creates a new record.
DbAppend( [<nLockMode>] ) --> NIL
DbClearRelation()
Clears all current relations in a work area.
DbClearRelation() --> NIL
DbDelete()
Marks record as deleted.
DbDelete() --> NIL
DbEval()
Evaluates a code block for each record in a work area.
DbEval( <bBlock>, [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>] ) --> NIL
DbExport()
Exports data from a work area into a new file.
DbExport( <cFilename>, [<aFieldNames>], [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>], [<cDbeName>], [<aDbeInfo>] ) --> NIL
DbImport()
Imports data from a file into a work area.
DbImport( <cFilename>, [<aFieldnames>], [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>], [<cDbeName>], [<aDbeInfo>] ) --> NIL
DbJoin()
Combines records from two work areas and writes the result to a new file.
DbJoin( <cAlias>, <cFilename>, [<aFieldnames>], [<bForCondition>] ) --> NIL
DbRecall()
Removes deletion flag for a record (recalls the record).
DbRecall() --> NIL
DbRelation()
Returns the linking expression of a relation.
DbRelation( <nRelation> | <cRelName> ) --> cLinkExpression
DbRList()
Returns a list of relation names defined for child work areas.
DbRList() --> aRelationNames
DbSetRelation()
Creates a relation (link) between two work areas.
DbSetRelation( <nWorkArea> | <cAlias>, <bRelation>, [<cRelation>], [<cTagName>], [<cRelName>], [<lSelective>] ) --> NIL
DbSort()
Sorts records from a work area and writes them into a file.
DbSort( <cFilename>, <aFieldnames>, [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>] ) --> lSuccess
DbTotal()
Totals data from numeric fields of a work area into a second file.
DbTotal( <cFilename>, <bIndexKey>, [<aFieldnames>], [<bForCondition>], [<bWhileCondition>], [<nCount>], [<xRecordID>], [<lRest>] ) --> NIL
DbUpdate()
Updates the current work area with data from another work area.
DbUpdate( <cAlias>, <bReplace>, <bIndexKey>, [<lRandom>] ) --> NIL
DELETE
Marks one or more records for deletion.
DELETE [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL] [IN <nWorkArea> | <cAlias> ] [NOOPTIMIZE]
DELETE - SQL
Deletes one or more records in a table. END
DELETE FROM <cTableName> [WHERE <lExpression>] [VIA (<coSession>)]
Deleted()
Determines whether a record is marked as deleted.
Deleted() --> lDeleted
DISPLAY
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]
FCount()
Determines the number of fields in the DBF file open in a work area.
FCount() --> nFieldCount
FieldGet()
Determines the value of a field in the current record of a work area.
FieldGet( <nFieldPos> ) --> xValue
FieldInfo()
Sets or returns the settings for a field.
FieldInfo( <nFieldPos>, <nDefine>, [<xNewSetting>] ) --> xOldValue
FieldName()
Return a field name from a work area.
FieldName( <nPosition> ) --> cFieldName
FieldPos()
Returns the position of a field in a work area.
FieldPos( <cFieldName> ) --> nFieldPosition
FieldPut()
Copies a value into a field of the current record in a work area.
FieldPut( <nFieldPos>, <Expression> ) --> xAssignedValue
GATHER NAME
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>]
INSERT - SQL
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>)]
JOIN
Joins records from two work areas and writes the results into a new file.
JOIN WITH <cAlias> TO <cFilename> [FOR <lCondition>] [FIELDS <cFieldname,...>]
LIST
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]
RECALL
Removes the deletion flag for one or more records.
RECALL [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL] [IN <nWorkArea> | <cAlias> ] [NOOPTIMIZE]
RecNo()
Returns a value which clearly identifies the current record.
RecNo() --> xRecordID
REPLACE
Assigns values to field variables.
REPLACE <cFieldname> WITH <Expression> [, <cFieldname> WITH <Expression>... ] [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [RECORD <xRecordID>] [REST] [ALL]
SCATTER NAME
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]
SELECT - SQL
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>]]
SET DELETED
Sets whether records with deletion flags will be visible.
SET DELETED on | OFF | <lToggle>
SET EXCLUSIVE
Determines whether files are opened as SHARED or EXCLUSIVE by default.
SET EXCLUSIVE on | OFF | <lToggle>
SET NULLVALUE
Enables/Disables NULL/NIL values for fields
SET NULLVALUE ON | off | <lToggle>
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
SORT
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]
SUM
Calculates sums for numeric expressions in the current work area.
SUM <nExpression,...> TO <VarName,...> [FOR <lForCondition>] [WHILE <lWhileCondition>] [NEXT <nCount>] [REST] [ALL]
TOTAL
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]
UPDATE
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>...]
UPDATE - SQL
Updates one or more records in a table. END
UPDATE <cTableName> SET <cFieldName> := <Expression>|<SubSelectExpression> [, ...] | FROM (aData|oData) WHERE <lExpression> [VIA (<coSession>)]