FieldType
Returns information about fieldName.
Format
FieldType ( fileName ; fieldName )
Parameters
fileName
- the name of an open database file (local or remote).
fieldName
- the name of a field in the specified database file.
Data type returned
text
Originated in version
6.0 or earlier
Description
Field names must be in the format tablename::fieldname
to specify a field that exists in a table different from the current table. The result has four values separated by spaces:
- The first value is either Standard, StoredCalc, Summary, UnstoredCalc, External(Secure), External(Open), or Global.
- The second value is the field type: text, number, date, time, timestamp, or container.
- The third value is Indexed or Unindexed.
- The fourth value is the maximum number of repetitions defined for the field (if the field isn’t defined as a repeating field, this value is 1).
Example 1
FieldType ( "Customers" ; "Phone Number" )
returns Standard Text Unindexed 3 when, in the Customers database file, the Phone Number field is defined as a text field that repeats a maximum of three times and the storage options are left unchanged. (Most fields are indexed when a find is performed in that field.)
Example 2
FieldType ( "Customers" ; "Current Balance" )
returns StoredCalc Number Indexed 1 when, in the Customers database file, the Current Balance field is defined as a stored, numeric calculation field that is indexed.
Example 3
FieldType ( "Customers" ; "Today’s Date" )
returns Global Date Unindexed 1 when, in the Customers database file, the Today’s Date field is defined as a global field of type date. Global fields are never indexed.
Example 4
FieldType ( "Customers" ; "Statement" )
returns External(Secure) Container Unindexed 1 when, in the Customers database file, the Statement field is defined as a container field that stores data externally using secure storage. Container fields cannot be indexed.