Get(FileName)

Category: Get

Syntax: Get ( FileName )

Parameters: None

Data type returned: Text

Description:

Returns the filename of the current database file without the file extension.

Get(FileName) is useful in function calls that require a filename, even if the current file is being referenced. This way, if the filename changes, you don't need to change any of your calculation formulas.

If a field in file Alpha.fp7 contains the formula Get (FileName), and that field is displayed on a layout in another file, Beta.fp7, via an external table occurrence, the field value will still return Alpha. Its context is rightly applied.

Examples:

Function

Results

Get (FileName)

Returns the value Contacts when the current database file is named Contacts.fp7.

GetNextSerialValue (Get (FileName); "Contacts:: PrimaryContactID")

Returns the next PrimaryContactID from the Contacts table in the current file. This function call is far less fragile than hard-coding the filename into the preceding expression. If the filename changes at some point in the future, this expression will continue to work as expected.


: 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

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net