MSCATALOG Structure
The MSCATALOG table has the following structure:
Column | Type(width) | Description |
---|---|---|
tablename | char(32) | table name |
entitynum | number(10) | unique entity or table number |
screenform | char(64) | screen form name |
reporttable | char(64) | report table name |
sqlreview | char(240) | default SQL review request |
fencefilter | char(240) | default SQL fence filter |
dastable | char(32) | displayable attributes table name |
formtable | char(64) | table used to locate screen form (optional) |
tablename Column
The tablename column in the MSCATALOG table contains the names of the tables in the database that are to be linked to elements. The table names must be added to the tablename column before linkages to elements are made. This is a required entry in the MSCATALOG table.
entitynum Column
The entitynum column in the MSCATALOG row for a particular table contains the entity number of the table. The entity number is a positive integer from 1 to 65535 that uniquely identifies the table to the database; each table used with a design must have a unique entity number. This is a required entry in the MSCATALOG table.
screenform Column
The screenform column in the MSCATALOG row for a particular table specifies the default screen form, used in conjunction with the VSQL Review key-in (VSQL REVIEW) if you are using VSQL, to review the database attributes of elements linked to rows in the table. If the optional formtable column exists in MSCATALOG, that column is examined to attempt to locate a saved VSQL form to be used instead of the default screen form. The screenform column will be used for both review and editing if formtable is empty. This is an optional entry in the MSCATALOG table.
reporttable Column
The reporttable column in the MSCATALOG row for a particular table contains the name of the report table that can be created with the Generate Report Table tool to report on the database attributes of elements linked to rows in the table. This column is ordinarily loaded with the key-in ACTIVE REPORT (RS=) but can be entered manually. This is an optional entry in the MSCATALOG table.
sqlreview Column
The sqlreview column in the MSCATALOG row for a particular table contains the SQL SELECT statement that is submitted with the Review Database Attributes of Element tool to review database attributes of elements linked to rows in the table. If this SQL statement is entered incorrectly or the column entry contains blank spaces, the SQL Review window is blank when the database linkages are reviewed. When this field is left empty, the default SQL statement: Select * From <tablename> is executed. This column is ordinarily loaded with the key-in ACTIVE REVIEW (RA=) but may be entered manually. This is an optional entry in the MSCATALOG table.
fencefilter Column
The fencefilter column in the MSCATALOG row for a particular table contains the SQL SELECT statement that determines which elements linked to rows in the table are selected for fence operations. This column must be loaded with the key-in DEFINE SEARCH (DS=) to function properly. This is an optional entry in the MSCATALOG table.
dastable Column
The dastable column in the MSCATALOG row for a particular table, specifies the displayable attributes table that is used. Displayable attributes post information from the database to text nodes placed in the DGN file.
Each row in a displayable attributes table (see the following table) specifies a displayable attribute type number and definition.
The sqldas column specifies a SQL SELECT statement that selects the attributes for display.