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. |