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.