Click above to get retro games delivered to your door ever month!

 Databases
-------------------------------------------------------------------------------
 Reference Item| Description
               |
 AFIELDS()     | Fill arrays with the structure of the current database file
 ALIAS()       | Return a specified work area alias
 APPEND BLANK  | Add a new record to current database file
 APPEND FROM   | Import records from a (.dbf) or ASCII file
 AVERAGE       | Average numeric expressions in the current work area
 BOF()         | Determine when beginning of file is encountered
 CLEAR ALL     | Close files and release public and private variables
 CLOSE         | Close a specific set of files
 COMMIT        | Perform a solid-disk write for all active work areas
 CONTINUE      | Resume a pending LOCATE
 COPY STRUCTURE| Copy the current (.dbf) structure to a new (.dbf) file
 COPY STRUCTURE|
    EXTENDED   | Copy field definitions to a (.dbf) file
 COPY TO       | Export records to a new (.dbf) or ASCII file
 COUNT         | Tally records to a variable
 CREATE        | Create an empty structure extended (.dbf) file
 CREATE FROM   | Create a new (.dbf) file from a structure extended file
 DBAPPEND()    | Add a new record
 DBCLEARFIL()  | Clear a filter condition
 DBCLOSEALL()  | Close all occupied workareas
 DBCLOSEAREA() | Close a workarea
 DBCOMMIT()    | Flush pending updates
 DBCOMMITALL() | Flush pending updates in all workareas
 DBCREATE()    | Create a database file from a database structure array
 DBDELETE()    | Mark a record for deletion
 DBEVAL()      | Evaluate a code block for each record
 DBF()         | Return current alias name
 DBFILTER()    | Return the current filter expression as a character string
 DBGOBOTTOM()  | Move to the last logical record
 DBGOTO()      | Move to a particular record
 DBGOTOP()     | Move to the first logical record
 DBRECALL()    | Reinstate a record marked for deletion
 DBSEEK()      | Search for a key value
 DBSELECTAR()  | Change the current workarea
 DBSETDRIVER() | Set the default database driver
 DBSETFILTER() | Set a filter condition
 DBSKIP()      | Move relative to the current record
 DBSTRUCT()    | Create an array containing the structure of a database file
 DBUSEAREA()   | Use a database file in a workarea
 DELETE        | Mark records for deletion
 DELETED()     | Return the deleted status of the current record
 EOF()         | Determine when end of file is encountered
 FCOUNT()      | Return the number of fields in the current (.dbf) file
 FIELD         | Declare database field names
 FIELDBLOCK()  | Return a set-get code block for a field variable
 FIELDGET()    | Retrieve the value for a field variable
 FIELDNAME()   | Return a field name from the current (.dbf) file
 FIELDPOS()    | Return the position of a field in a workarea
 FIELDPUT()    | Set the value of a field variable
 FIELDWBLOCK() | Return a set-get block for a field in a given workarea
 FIND          | Search an index for a specified key value
 FOUND()       | Determine if the previous search operation succeeded
 GO            | Move the record pointer to a specific record
 HEADER()      | Return the current database file header length
 JOIN          | Create a new database file by merging record/fields
 LASTREC()     | Determine the number of records in the current (.dbf) file
 LOCATE        | Search sequentially for a record matching a condition
 LUPDATE()     | Return the last modification date of a (.dbf) file
 PACK          | Remove deleted records from a database file
 RECALL        | Restore records marked for deletion
 RECCOUNT()    | Determine the number of records in the current (.dbf) file
 RECNO()       | Return the current record number of a work area
 RECSIZE()     | Determine the record length of a database (.dbf) file
 REPLACE       | Assign new values to field variables
 SEEK          | Search an index for a specified key value
 SELECT        | Change the current work area
 SELECT()      | Determine the work area number of a specified alias
 SET DELETED   | Toggle filtering of deleted records
 SET EXCLUSIVE | Establish shared or exclusive USE of database files
 SET FILTER    | Hide records not meeting a condition
 SET PATH      | Specify the CA-Clipper search path for opening files
 SET SOFTSEEK  | Toggle relative SEEKing
 SET UNIQUE    | Toggle the inclusion of nonunique keys into an index
 SKIP          | Move the record pointer to a new position
 SORT          | Copy to a (.dbf) file in sorted order
 SUM           | Sum numeric expressions to variables
 TOTAL         | Summarize records by key value to a (.dbf) file
 UPDATE        | Update current database file from another database file
 USE           | Open an existing (.dbf) and its associated files
 USED()        | Determine if a database file is in USE
 ZAP           | Remove all records from the current database file
-------------------------------------------------------------------------------