Functions Reference

FILEMAKER FUNCTIONS REFERENCE 42
DatabaseNames
Purpose
Returns a list of the names of all database files open on the computer, separated by carriage
returns.
Format
DatabaseNames
Parameters
None
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Description
The names returned do not include file extensions.
Note If your database is hosted on another computer, DatabaseNames returns a list of the names
of local client and remote database files open only on the client computer.
Examples
To determine whether Customers is one of the files currently open, use the DatabaseNames
function with the
FilterValues function in the formula:
FilterValues( DatabaseNames;"Customers")
If the formula returns any text value, then Customers is open.
If you want to know how many files with the same name are open, use the DatabaseNames
function with the
PatternCount function in the formula:
PatternCount(FilterValues(DatabaseNames;"Customers");"Customers")
This will tell you how many files named Customers are open.
TableNames A list of the names of all defined tables in the specified database file, separated by
carriage returns.
ValueListIDs A list of all value list IDs in the specified database file, separated by carriage
returns.
ValueListItems A list of the values in the specified value list, separated by carriage returns.
ValueListNames A list of the names of all value lists in the specified database file, separated by
carriage returns.
WindowNames A list of the names of open windows in the specified database file.
This function Returns