FieldNames()

Category: Design

Syntax: FieldNames ( fileName; layout/tableName )

Parameters:

fileNameThe name of an open FileMaker database from which to return field names.

layout/tableNameThe name of the layout or table to reference.

Data type returned: Text

Description:

Returns a carriage returndelimited list of field names.

When a table name is given (and is not also serving as a layout name), all fields for that table are returned. If a layout has the same name as a table, FileMaker will turn first to the layout in question and return only those fields that have been placed on that layout.

FieldNames() can be used to dynamically generate database structure information about any open FileMaker database.

When information about fields in a table is returned, the results are ordered according to the creation order of the fields. When the names of the fields on a particular layout are returned, the results are ordered according to the stacking order of the fields, from back to front. If an object appears on a layout more than once, it appears multiple times in the result list. Related fields appear as RelationshipName::FieldName.

Examples:

Function

Results

FieldNames ( Get ( FileName ); "Customers" )

Returns a list of fields found in the table named Customers in the current database (assuming there isn't a layout named "Customers").



: 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