The DBFIELDCOUNT function returns the number of fields in a database object.
database is the name of a database and must include the full path if not in the same directory as the open document.
source is the name of the database object, which can be a table, query, relation or SQL statement.
For example, if there is a database called wineshop.adb in a folder c:\ability\samples, which contains a table called Contacts, then:
DBFIELDCOUNT("c:\ability\samples\wineshop.adb", "Contacts")
returns the number of fields.
See also: