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 Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information



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

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