Category > Database commands

 

Item	Description
APPEND BLANK	Creates a new record in the current work area.
APPEND FROM	Imports records from a database file or an ASCII text file.
AVERAGE	Calculates the average of numeric expressions in the current work area.
CLOSE	Closes one or more specified files.
COMMIT	Writes memory buffers of all used work areas to disk.
CONTINUE	Resumes a pending LOCATE command.
COPY STRUCTURE	Copies the current database structure to a new database file.
COPY STRUCTURE EXTENDED	Copies field information to a new database file.
COPY TO	Exports records from the current work area to a database or an ASCII text file.
COUNT	Counts records in the current work area.
CREATE	Creates and opens an empty structure extended database file.
CREATE FROM	Creates a new database file from a structure extended file.
DELETE	Marks one or more records for deletion.
DELETE TAG	Deletes a tag from an index.
FIND	Searches an index for a specified key value.
GO	Moves the record pointer to a specified position.
INDEX	Creates an index and/or index file.
JOIN	Merges records of two work areas into a new database.
LIST	Lists records of a work area to the console, file or printer.
LOCATE	Scans the current work area for a record matching a condition.
PACK	Removes records marked for deletion physically from a database file.
RECALL	Removes a deletion mark from one or more records.
REINDEX	Rebuilds all open indexes in the current work area.
REPLACE	Assigns values to field variables.
SEEK	Searches a value in an index.
SELECT	Changes the current work area.
SET AUTOPEN	Toggles automatic opening of a structural index file.
SET AUTORDER	Defines the default controlling index for automatically opened index files.
SET AUTOSHARE	Defines network detection for shared file access.
SET DBFLOCKSCHEME	Selects the locking scheme for shared database access.
SET DELETED	Specifies visibility of records marked for deletion.
SET EXCLUSIVE	Sets the global EXCLUSIVE open mode for databases.
SET FILTER	Defines a condition for filtering records in the current work area.
SET HARDCOMMIT	Toggles immediate committing of changes to record buffers.
SET INDEX	Opens one or more index files in the current work area.
SET MEMOBLOCK	Defines the default block size for memo files.
SET OPTIMIZE	Toggles filter optimization with indexed databases.
SET ORDER	Selects the controlling index.
SET RELATION	Synchronizes the record pointers in one or more work areas.
SET SCOPE	Changes the top and/or bottom scope for navigating in the controlling index.
SET SCOPEBOTTOM	Changes the bottom scope for navigating in the controlling index.
SET SCOPETOP	Changes the top scope for navigating in the controlling index.
SET STRICTREAD	Toggles read optimization for database access.
SKIP	Moves the record pointer to a new position.
SORT	Creates a new, physically sorted database.
SUM	Calculates the sum of numeric expressions in the current work area.
TOTAL	Creates a new database summarizing numeric fields by an expression.
UNLOCK	Releases file and/or record locks in the current or all work areas
UPDATE	Updates records in the current work area from a second work area.
USE	Opens a database and its associated files in a work area.
ZAP	Delete all records from the current database file