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.