object_id

integer

Object ID of the frame.

fr_seq

smallint

Sequence number (for ordering).

var_field

varchar(32)

Field name.

var_column

varchar(32)

Column name (if field is a table field).

var_datatype

varchar(105)

Data type of the field.

var_comment

varchar(60)

Comment for the variable.

object_id

integer

Object ID of frame.

mu_text

varchar(32)

Menu item text.

mu_seq

smallint

Sequence number beginning at 0 (for argument ordering).

mu_field

varchar(32)

Field name in called frame to assign value to. If field name is of the form X.Y, this contains the X portion only.

mu_column

varchar(32)

Portion of field name in called frame to assign value to. Only used when field name is of form X.Y, in which case this contains the Y portion.

mu_expr

varchar(240)

4GL expression (field, constant, byref(), etc.) in the parent frame to assign to field in the called frame.

object_id

integer

Object ID of the frame.

vq_seq

smallint

Sequence number (for ordering).

join_type

smallint

Type of join specified by this row.
0 = Master/Detail join.
1 = Master/Lookup join.
2 = Detail/Lookup join.

join_tab1

smallint

Index to table 1 of the join. Relative table number in visual query beginning with 0.

join_tab2

smallint

Index to table 2 of the join. Relative table number in visual query beginning with 0. (table 2 is always below table 1 in visual query).

join_col1

smallint

Join column for table 1. Index into array of columns for table 1. (Same as ii_vqtabcols.vq_seq).

join_col2

smallint

Join column for table 2. Index into array of columns for table 2. (Same as ii_vqtabcols.vq_seq).

object_id

integer

Object ID of the frame.

vq_seq

smallint

Column sequence number (for ordering).

tvq_seq

smallint

Sequence number of table in visual query from ii_vqtables.

col_name

varchar(32)

Column name.

ref_name

varchar(32)

Name used on the form for field containing data.

adf_type

smallint

Type information for column. See description of iicolumns. column_ingdatatype for details.

adf_length

integer

Column size in bytes.

adf_scale

integer

Currently not used.

col_flags

integer

This column contains multiple pieces of information about the column in a bitmap format. The following values are present (expressed in Hex):
1 = Column is to be used on form/report.
2 = Column is joined to a detail table and must be displayed.
4 = Column is joined to a lookup table and must be displayed.
8 = Column is a subordinate join field; therefore it cannot be displayed.

0x10 = Column is sequenced (generate new surrogate key value for INSERT statements).
0x20 = Column is descending (for sort).
0x40 = Column is part of the table's unique key.
0x100 = Set if column allows defaults.

col_sortorder

smallint

Sort order for this column. Set to 0 if not part of sort sequence. For lookup tables, this gives the order of the column in the lookup screen.

col_info

varchar(240)

Information entered by developer for this column in visual query. For Browse & Update frames, this is a query restriction and is added to the WHERE clause of the SELECT statement. For Append frames, this gives default value information and is either used in 4gl assignment statements for a displayed column, or in the INSERT statement for a not-displayed column.

object_id

integer

Object ID of the frame.

vq_seq

smallint

Order of table in visual query.

vq_mode

smallint

This column contains multiple pieces of information about the frame as a whole, in a bitmap format (although note that the first 4 entries below are mutually exclusive; only one of them can appear). Can contain the following values (in Hex):
0 = Frame has no tables (menu frame).
1 = Master/Detail frame.
2 = Master only in a table field.
3 = Master only in simple fields.

0x10 = If set, the Qualification Processing frame behavior is Disabled (can only be set for Browse & Update frames)
0x20 = If set, the Next Master Menuitem frame behavior is Disabled (can only be set for Browse & Update frames)
0x40 = If set, the"Hold Locks on Displayed Data frame behavior is set to Yes (can only be set for Update frames).

tab_name

varchar(32)

Table name.

tab_owner

varchar(32)

Table owner.

tab_section

smallint

Visual query section table is in.
0 = table is in master section.
1 = table is in detail section.

tab_usage

smallint

How this table is used in the visual query.
0 = Append table.
1 = Update table.
2 = Browse table.
3 = Lookup table.

tab_flags

integer

Bitmap flag that indicates the frame behaviors in the visual query. Valid values (in Hex):
0x1 = For lookup table: lookup requires a qualification screen. For update table: insertions are allowed into the table field (only relevant to the detail table, and to masters in table field)
0x2 = OK to Delete data in this table.
0x4 = If set: update of join field cascades to detail; if clear: update of join field not allowed if details exist.
0x8 = If set: delete of master cascades to detail; if clear: delete of master not allowed if details exist.
0x10 = Table does not have a unique key.
0x20 = DBMS handles referential integrity on details when join field is changed. Generated code updates master table only.
0x40 = DBMS handles referential integrity on details when master is deleted.