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.






FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352
Simiral book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net