DatabaseNames
Purpose
Returns a list of the names of all files open on the computer.
Format
DatabaseNames
Parameters
None
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Description
Listed items are separated by carriage returns. 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.
Related topics