Reference > Functions reference > Design functions > DatabaseNames

DatabaseNames

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.

Notes

•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.

Example 1

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.

Example 2

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.