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