FieldType()

Category: Design

Syntax: FieldType ( fileName; fieldName )

Parameters:

fileNameThe name of the open file where the field is located.

fieldNameThe name of the field for which to return results.

Data type returned: Text

Description:

Returns a space-delimited string indicating the field type of the field specified by fieldName. There are four components to the string, each of which can contain several possible values. The possible values for each item are

Item 1: standard, storedcalc, summary, unstoredcalc, or global

Item 2: text, number, date, time, timestamp, or container

Item 3: indexed or unindexed

Item 4: Number of repetitions (1 for a non-repeating field)

fieldName must be specified as Table::Field when referencing fields in tables outside of the current table context.

Using the Table::Field method for referencing fields as a matter of course avoids broken references when the current table context changes.

Examples:

Function

Results

FieldType ( Get (FileName); "Contacts::ContactID" )

Might return values that look like this: standard number indexed 1.

FieldType ( Get (FileName); "Contacts::gTempName" )

Might return values that look like this: global text unindexed 1.







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