Checking the database structure

After the database has been created or modified, the program checks the structure of the database and displays a message if any problems were detected. Such problem can be, for example, a missing field or wrong field type.

Example report:

Field <DmPartCode> is not defined in table <EQUIPMENTS>

type = STRING len = 37 editable = yes

In this case, the String type field "DmPartCode" is missing from the table EQUIPMENTS. This required field's length is 37 and it is editable.

Note: The error list is saved as a text file in the working area directory, with the name Db_Check_file.txt.

To correct the problems, add the missing fields and make the requested modifications. To do this, open the CADMATIC desktop, select Object > Manage Diagram Database, and then click Manage Database Tables.

Important: It is very important to fix database errors before starting to use CADMATIC P&ID.