Was this helpful?
ii_vqtables Catalog
The ii_vqtables catalog describes the tables involved in a visual query:
Column Name
Data Type
Description
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.
Last modified date: 01/30/2023