@BASE's functions are like their dBase counterparts and allow you to specify precisely the scope of your search. If criteria have been specified through the prompts, then @BASE returns the results of the specified subset of the database, otherwise, most formulas also allow you to specify criteria in the formula.
The following are some of the special database @functions that can be used if BASEFUNC.ADN is attached.
@dbavg -- returns the average value of a specified field for all the records in the database file.
@dbclose -- closes specified database file.
@dbcnt -- returns the number of records in a database file.
@dbfirst -- returns the record number of the first record found in a specified database file that meets the active and/or optional criteria.
@dbfld -- returns the contents of a specified field contained in a specified record number.
@dbisact -- returns a 1 if a specified record is not marked for deletion and meets the active and/or optional criteria. Otherwise returns a 0.
@dbisdel -- returns a 1 if specified record is marked for deletion. Otherwise returns a 0.
@dbisna -- returns a 1 if a field of a specified record has no value. If the field does have a value, the function returns a 0.
@dbmax -- returns the largest value in a specified field.
@dbmin -- returns the minimum value in a specified field.
@dbnext -- returns the record number of the next record in the database matching the active and/or optional criteria.
@dbopen -- opens a database file.
@dbrecs -- returns the total number of records in the database file.
@dbsum -- returns the sum of the values in a specified field.
@dbupd -- replaces the contents of a specified field and record with a specified value.