Get(FilePath)

Category: Get

Syntax: Get ( FilePath )

Parameters: None

Data type returned: Text

Description:

Returns the full path to the currently active database file, including the file extension.

Returns file:/driveletter:/databaseName for local files in Windows.

Returns file://volumename/myfoldername/databaseName for remote files in Windows.

Returns file:/path/databaseName for local and remote files in the Mac OS.

Returns fmnet:/networkaddress/databaseName for FileMaker Pro networked files.

Remember that Get (FilePath) includes the filename and extension. Text parsing functions can be used to extract just the file path from the results returned by Get (FilePath). This can be useful for building dynamic paths to objects that are in the same directory as the current file.

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

Examples:

Function	Results
Get (FilePath)	Returns the current file path.
Left (Get (FilePath); Position ( Get (FilePath); Get (FileName); 1; 1) -1)	Returns just the path to the current file directory. The Position() function truncates the path before the filename.