Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Design functions > DatabaseNames function |
|
|
| DatabaseNames function |
| Format |
DatabaseNames |
| Parameter |
| None |
| Data type returned |
| text |
| Description |
| Returns a list of the names of all database files open on the computer, separated by carriage returns. The names 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 called "Customers" are open. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Design functions > DatabaseNames function |
|
|
Next Page |
|