Database


AFIELDS()Fills referenced arrays with database field information
ALIAS()Returns the alias name of a work area
BOF()Test for the beggining-of-file condition
DBAPPEND()Appends a new record to a database file.
DBCLEARFILTER()Clears the current filter condiction in a work area
DBCLOSEALL()Close all open files in all work areas.
DBCLOSEAREA()Close a database file in a work area.
DBCOMMIT()Updates all index and database buffers for a given workarea
DBCOMMITALL()Flushes the memory buffer and performs a hard-disk write
DBCREATE()Creates an empty database from a array.
DBDELETE()Marks records for deletion in a database.
DBEVAL()Performs a code block operation on the current Database
DBF()Alias name of a work area
DBFILTER()Return the filter expression in a work area
DBGOBOTTOM()Moves the record pointer to the bottom of the database.
DBGOTO()Position the record pointer to a specific location.
DBGOTOP()Moves the record pointer to the bottom of the database.
DBRECALL()Recalls a record previousy marked for deletion.
DBRLOCK()This function locks the record basedon identify
DBRLOCKLIST()This function return a list of records in the database work area
DBRUNLOCK()Unlocks a record base on its indentifier
DBSEEK()Searches for a value based on an active index.
DBSELECTAREA()Change to another work area
DBSETDRIVER()Establishes the name of replaceable daabas driver for a selected work area
DBSETFILTER()Establishes a filter condition for a work area.
DBSKIP()Moves the record pointer in the selected work area.
DBSTRUCT()Creates a multidimensional array of a database structure.
DBUNLOCK()Unlock a record or release a file lock
DBUNLOCKALL()Unlocks all records and releases all file locks in all work areas.
DBUSEAREA()Opens a work area and uses a database file.
DELETED()Tests the record's deletion flag.
EOF()Test for end-of-file condition.
FCOUNT()Counts the number of fields in an active database.
FIELDGET()Obtains the value of a specified field
FIELDNAME()Return the name of a field at a numeric field location.
FIELDPOS()Return the ordinal position of a field.
FIELDPUT()Set the value of a field variable
FLOCK()Locks a file
FOUND()Determine the success of a previous search operation.
HEADER()Return the length of a database file header
INDEXEXT()Returns the file extension of the index module used in an application
INDEXKEY()Yields the key expression of a specified index file.
INDEXORD()Returns the numeric position of the controlling index.
LASTREC()Returns the number of records in an active work area or database.
LUPDATE()Yields the date the database was last updated.
NETERR()Tests the success of a network function
ORDBAGEXT()Returns the Order Bag extension
ORDBAGNAME()Returns the Order Bag Name.
ORDCONDSET()Set the Condition and scope for an order
ORDCREATE()Create an Order in an Order Bag
ORDDESTROY()Remove an Order from an Order Bag
ORDFOR()Return the FOR expression of an Order
ORDKEY()Return the key expression of an Order
ORDLISTADD()Add Orders to the Order List
ORDLISTCLEAR()Clear the current Order List
ORDLISTREBUILD()Rebuild all Orders in the Order List of the current work area
ORDNAME()Return the name of an Order in the Order List
ORDNUMBER()Return the position of an Order in the current Order List
ORDSETFOCUS()Set focus to an Order in an Order List
RDDLIST()Return an array of the available Replaceable Database Drivers
RDDNAME()Return the name of the currently active RDD
RDDSETDEFAULT()Set or return the default RDD for the application
RECCOUNT()Counts the number of records in a database.
RECNO()Returns the current record number or identity.
RECSIZE()Returns the size of a single record in an active database.
RLOCK()Lock a record in a work area
SELECT()Returns the work area number for a specified alias.
USED()Checks whether a database is in use in a work area
__DBCONTINUE()Resume a pending LOCATE
__DBZAP()Remove all records from the current database file
__FLEDIT()*Filter a database structure array
__RDDSETDEFAULT()Set or return the default RDD for the application
__dbCopyStruct()Create a new database based on current database structure
__dbCopyXStruct()Copy current database structure into a definition file
__dbCreate()Create structure extended file or use one to create new file
__dbStructFilter()Filter a database structure array
dbSkipper()Helper function to skip a database