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.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.