Fieldtype

Syntax

result = fieldtype (tag_or_field_name)

Arguments

result: integer

tag_or_field_name: text

Meaning

Yields the data type of the field (only the number of the type) as defined in the data dictionary. The different data types have the following numbers:

1 TEXT
2 LETTERS ONLY
3 NUMERIC
4 INTEGER
5 GENERAL DATE
6 DATE (USA) MM/DD/YYYY
7 DATE (EUR) DD/MM/YYYY
8 DATE (ISO) YYYY-MM-DD
9 TIME
10 ISBN
11 ISSN
12 LOGICAL
13 ENUMERATE
14 APPLICATION
15 IMAGE
16 TEMPORARY

Example 1

result = fieldtype ('object.name.notes')

Result

Result = 1.

Example 2

result = fieldtype ('acquisition.price.value')

Result

Result = 3.