QUE CORPORATION - Using Filemaker pro X

Get(FilePath)

Category: Get

Syntax: Get ( FilePath )

Parameters: none

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.

Examples:

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.

Comments:

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