Group Table Operations

Fills a set of arrays with information about the fields in a work area.

AFields( [<aFieldName>], [<aFieldType>], [<aFieldLen>], [<aFieldDec>] ) --> nFieldCount

Returns the alias name for a work area.

Alias( [<nWorkArea>] ) --> cAlias

Closes all files or a specific group of files.

CLOSE [<cAlias> | ALL | ALTERNATE | DATABASES | INDEXES]

Writes contents of file buffers from all work areas back into the files.

COMMIT

Copies the structure of the file in the current work area to a new file.

COPY STRUCTURE [FIELDS <cFieldname,...>] TO <cFilename>

Copies a list of field definitions to a new file.

COPY STRUCTURE EXTENDED TO <cFilename>

Exports records from a work area into a new file.

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

Creates and opens an empty structure extended DBF file.

CREATE <cFilename>

Creates and opens a new database from a structure extended file.

CREATE <cDbFile> FROM <cStructFile> [ALIAS <cAlias>] [VIA <cDbeName>] [NEW]

Attaches an arbitrary value to a used work area

DbCargo( [<xNewValue>] ) --> xOldValue

Returns a list of the Xbase Parts registered in a work area.

DbClientList() --> aXbaseParts

Closes all files in all work areas.

DbCloseAll() --> NIL

Closes files in a work area.

DbCloseArea() --> NIL

Writes file buffers in a work area into the files.

DbCommit() --> NIL

Writes file buffers in all work areas into files.

DbCommitAll() --> NIL

Copies the field structure from a work area into a structure extended file.

DbCopyExtStruct( <cFilename> ) --> lSuccess

Creates a file with the same structure as the file open in a work area.

DbCopyStruct( <cFilename>, [<aFieldNames>] ) --> lSuccess

Generates a database file from a file structure array.

DbCreate( <cDbfFile>, <aStructure>, [<cDBE|<oSession>] ) --> NIL

Creates and opens an empty structure extended file.

DbCreateExtStruct( <cFilename> ) --> lSuccess

Creates and opens a new file from a structure extended file.

DbCreateFrom( <cNewFilename>, [<cNewDbeName>], <cStructFile>, [<cStructDbeName>], [<lNewArea>], [<cAlias>] ) --> NIL

Removes an Xbase Part from a work area's list of registered Xbase Parts.

DbDeregisterClient( [<oXbp>] ) --> lSuccess

Permanently deletes a table

DbDestroy() --> NIL

Returns the alias name of the current work area.

Dbf() --> cAlias

Sets or returns information about a work area (database object).

DbInfo( <nDefine>, [<xNewSetting>] ) --> xOldSetting

Retrieves the code block associated with a work area.

DbJob() --> bAreaBlock | NIL

Checks if a table lock is set.

DbLocked() --> lIsFileLocked

Physically removes records marked as deleted from a file.

DbPack() --> NIL

Forces refresh of all internal cache buffers of current work area

DbRefresh() --> NIL

Registers an object to receive messages from a work area.

DbRegisterClient( <object> ) --> lSuccess

Transfers an alias name from the current work space into the Zero space.

DbRelease( [<nWorkArea>|<cAlias>], [<bAreaBlock>] ) --> lSuccess

Transfers an alias name from the Zero space into the current work space.

DbRequest( [<cAlias>], [<lFreeArea>], [<@bAreaBlock>], [<lWait>] ) --> lSuccess

Reactivates notifications being sent from a work area to registered objects.

DbResetNotifications( [<lChildAreas>] ) --> lActivated

Reactivates notifications being sent from a work area to registered objects.

DbResumeNotifications( [<lChildAreas>] ) --> lActivated

Executes a roll back operation on the current table row.

DbRRollback() --> NIL

Returns the child work area of a relation.

DbRSelect( <nRelation> | <cRelName> ) --> nWorkarea

Suspends a relational restriction in a child work area.

DbRSuspendSelect() --> NIL

Checks if a scope is set in a work area.

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

Opens an index file in a work area.

DbSetIndex( <cIndexFile> ) --> NIL

Toggles NULL/NIL value support of a work area

DbSetNullValue([<lNullAllowed>]) -> lNullAllowed

Generates an array containing the structure data for a database file. When no database file is open in the work area, an empty array ({}) is returned.

DbStruct() --> aStructure

Temporarily suspends notifications being sent from a work area to registered objects.

DbSuspendNotifications( [<lChildAreas>] ) --> NIL

Opens a database file in a work area.

DbUseArea( [<lNewArea>], [<cDBE>|<oSession>], <cFileName>, [<cAlias>], [<lShared>], [<lReadonly>] ) --> NIL

Deletes all records in a work area.

DbZap() --> NIL

Writes contents of all file buffers from a single current work area to disk.

FLUSH [[IN <nWorkArea> | <cAlias> ] | [ <cFileSpec> ]] [FORCE]

Determines the length of the file header of an opened DBF file.

Header() --> nBytes

Returns the date of the last change to a database file.

LUpdate() --> dDate

Physically removes records marked for deletion from a table.

PACK [DBF][MEMO] [IN <nWorkArea> | <cAlias> ] | [cFileSpec]

Returns the length of a record in a work area.

RecSize() --> nBytes

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

SET EXCLUSIVE on | OFF | <lToggle>

Opens a database file and its accompanying files in a work area.

USE [ <cFileName> [ INDEX <cIndexFiles,...> ] [ ALIAS <cAlias> ] [ VIA <cDbeName> | (<oSession>) ] [ NEW ] [ READONLY ] [ EXCLUSIVE | SHARED ] ]

Determines whether a file is open in a work area.

Used([<nWorkArea> | <cAlias>]) --> lIsUsed

Evaluates a code block in all used work areas of a work space

WorkSpaceEval( <bAreaBlock>, [<nWorkSpace>] ) --> nProcessed

Retrieves alias names of all used work areas in a work space.

WorkSpaceList( [<nWorkSpace>] ) --> aAliasNames

Deletes all records in the current work area or in the work area specified with the IN clause

ZAP [IN <nWorkArea> | <cAlias> ]