Was this helpful?
ii_fields Catalog
The ii_fields catalog contains information on the fields in a form. For every form, there is one row in this catalog for each field, table field and table field column. As used below, the word field refers to a simple field, a table field or a column in a table field. An example of a query that selects information about fields on a form is in Sample Queries for the Extended System Catalogs for SQL.
The ii_fields catalog is structured as btree unique on the object_id and flsubseq columns:
Column Name
Data Type
Description
object_id
integer
Unique identifier (object ID) for identifying the form this field belongs to in the ii_objects catalog. Other information about the form (such as name, owner, and object class) is stored in the ii_objects catalog.
flseq
smallint
The sequence number of the field in the form (or column in a table field). This determines the tabbing order among fields and among columns in a table field.
fldname
varchar(32)
The name of the field.
fldatatype
smallint
The data type of the field. Possible values are listed here with nullable data types being the negative of the listed value:
3 date
5 money
20 char
21 varchar
30 integer
31 floating point
32 c
37 text
fllength
smallint
The internal data length of the field in bytes. This cannot be the same as the user-defined length. This is the length used by Ingres.
flprec
smallint
Reserved for future use.
flwidth
smallint
The number of characters displayed in the field on the form including wrap characters. For example, if the format for the field is c20.10, flwidth is 20.
If the field is a table field, this value is the number of columns in the table field.
flmaxlin
smallint
The number of lines occupied by the field (title and data).
flmaxcol
smallint
The number of columns occupied by the field (title and data).
flposy
smallint
The y coordinate of the upper left corner of the field.
flposx
smallint
The x coordinate of the upper left corner of the field.
fldatawidth
smallint
The width of the data entry area for the field. If field format is c20.10, fldatawidth is 10.
fldatalin
smallint
The y-coordinate position of the data entry area relative to the upper left corner of the field.
fldatacol
smallint
The x-coordinate position of the data entry area relative to the upper left corner of the field.
fltitle
varchar(50)
The field title.
fltitcol
smallint
The x-coordinate position of the title relative to the upper left corner of the field.
fltitlin
smallint
The y-coordinate position of the title relative to the upper left corner of the field.
flintrp
smallint
Reserved for future use.
fldflags
integer
The field attributes, such as box and reverse video. Valid (octal) values are:
1 boxed field
04 query-only
10 keep previous values
20 mandatory
40 no row lines (table field)
100 force lowercase
200 force uppercase
400 reverse video
1000 blinking
2000 underline
4000 change intensity
10000 no autotab
20000 no echo
40000 no column title (table field only)
200000 foreground color 1
400000 foreground color 2
1000000 foreground color 3
2000000 foreground color 4
4000000 foreground color 5
10000000 foreground color 6
20000000 foreground color 7
100000000 invisible
10000000000 row highlight (table field)
fld2flags
integer
More attributes for the field, including scrolling:
0100 scrollable
01000 display-only
04000 derived field
fldfont
smallint
Reserved for future use.
fldptsz
smallint
Reserved for future use.
fldefault
varchar(50)
The default value for the field.
flformat
varchar(50)
The display format for the field (for example, c10 or f10.2).
flvalmsg
varchar(100)
The message to be displayed if the validation check fails.
flvalchk
varchar(240)
The validation check for the field.
fltype
smallint
Indicates if the record describes a regular field, a table field or a column in a table field. Possible values are:
0 simple field;
1 table field;
2 table field column;
flsubseq
smallint
A unique identifying record number with respect to the set of records that describe all the fields in a form.
Last modified date: 01/30/2023