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 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352
Simiral book on Amazon

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