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. |