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 version 

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.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas