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 |
http://www.xHarbour.com