DBFIELDNAME(database, source, index)

The DBFIELDNAME function returns the name of a field 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.

index is a field number.

The function arguments are case insensitive.

For example, if there is a database called wineshop.adb in a folder c:\ability\samples, which contains a table called Contacts, then:

DBFIELDNAME("c:\ability\samples\wineshop.adb", "Contacts", 1)

returns the name of the first field in the table.

See also:

Other remote functions