DBFIELDCOUNT(database, source)

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:

Other remote functions