Category: Design

Syntax: DatabaseNames



Data type returned: Text

Description: Returns a carriage returndelimited list of currently open databases (filenames), whether open as a client of another machine or open locally.

Note that on Windows, the .fp7 extension is not returned. This means that the function is consistent across both platforms.

Use caution when checking for hard-coded strings in calculations. If someone renames a file, any calculation containing the old value will no longer behave as before. Get (FileName) can be used in conjunction with a startup script to see whether a filename has been changed, and developers may want to consider establishing a centrally controlled custom function or variable for such checks.


In a circumstance where three files are open, Customers, Invoices, and Invoice Line Items, DatabaseNames() will return Customers¶Invoices¶Invoice_Line_Items.

PatternCount ( DatabaseNames; "Customers" )

Returns 1 if the Customers database is open.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: