Get(FileName)

Get(FileName)

Category: Get

Syntax: Get ( FileName )

Parameters: none

Description: Returns the filename of the current database file, without the file extension.

Examples:

 Get (FileName) 

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

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

Returns the next PrimaryContactID from the Contacts table in the current file.

Comments:

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 A.fp7 contains the formula Get (FileName) , and that field is displayed on a layout in another file, B.fp7 , via an external table occurrence, the field value will still return A .