Harbour Database Functions

Database Functions

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	Mark a record 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 top of the database
dbRecall	Recalls a record previousy marked for deletion
dbSeek	Searches for a value based on an active index
dbSelectArea	Change to another work area
dbSetDriver	Establishes the RDD name for the selected work area
dbSetFilter	Establishes a filter condition for a work area
dbSkip	Moves the record pointer in the selected work area
dbSkipper	Helper function to skip a database
dbStruct	Builds a multidimensional array of a database structure
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
FieldDeci	Determines the number of decimal places of a given numeric field
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
FieldSize	Determines the size of a given field
FieldType	Determines the type of a given field
Found	Determine the success of a previous search operation
Header	Return the length of a database file header
LastRec	Returns the number of records in an active work area or database
LUpdate	Yields the date the database was last updated
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
Select	Returns the work area number for a specified alias
Used	Checks whether a database is in use in a work area