[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
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
-------------------------------------------------------------------------------
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson