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. |