Files > SQLI_DATA_TYPE

name
SQLI_DATA_TYPE
number
1.5211
location
^DMSQ("DT",
description
A set of values from which all domains of that type may be drawn. PRIMARY_KEY - the set of all primary keys (in SQLI_TABLE_ELEMENT, type P) CHARACTER - the set of all character strings of length less than 256 INTEGER - the set of all cardinal numbers NUMERIC - the set of all real numbers DATE - the set of all date valued tokens TIME - the set of all time valued tokens MOMENT - the set of all tokens which have both a date and a time value BOOLEAN - the set of all tokens which evaluate to true or false only MEMO - the set of all character strings of length > 255
Fields
#NameLocationTypeDetailsIndexDescription
.01d name(+)0;1FREE TEXTBODBC Standard data type corresponding to FileMan domains
1d comment0;2FREE TEXTShort description of the data type
2d output strategy1;E1,245FREE TEXTM code which returns external value, {E} of base value, {B}.
3d output format0;3POINTER1.5214IEN of default output format in SQLI_OUTPUT_FORMAT

Referenced by 3 types

  1. SQLI_DOMAIN (1.5212) -- dm_data_type
  2. SQLI_KEY_FORMAT (1.5213) -- kf_data_type
  3. SQLI_OUTPUT_FORMAT (1.5214) -- of_data_type