Managing Database Table Properties - Intergraph Smart Engineering Manager - 2019 (10.0) - Help - Hexagon

Data Dictionary Manager Help

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Help
Smart P&ID Version
9 (2019)
Smart Engineering Manager Version
10 (2019)

With database table properties, you can control various aspects of the database. These properties are characteristics or items in a particular database table.

You can define properties for items that you need to work with in supported engineering products, as well as properties for items that you need in the background to run the software. You can also define class IDs of programs that validate and calculate specific properties.

You can define a combination of the following attributes for each property:

  • Name (required)

  • Display name used for the property in the Properties window

  • Type of data associated with the property

  • Select list that defines possible choices for the property, if applicable

  • Format for the property

  • Default value of the property, if applicable

  • Maximum length of values for the property, if the data type is a string

  • Calculation or validation program ID associated with the property, if applicable

  • Category of the property

You can also determine whether you want users to see each database property in the engineering product and whether you want users to see the property when creating filters in Filter Manager.

After you define properties, you cannot change the values for the name, data type, or maximum length of the property. You can make changes to the select list for the property if the selected data type has a select list associated with it. Changing the select list for a property can affect the integrity of previously saved data for that property. You can make changes to any other attributes of the property at any time.

  • New properties do not require specification of the Format attribute in order to appear in the design software. However, properties with Format equal to None do not appear in the plant data properties when viewed from Smart Engineering Manager.

  • We recommend using ASCII characters for internal names of added properties. When using the Data Dictionary Manager to add a new property, you must enter an internal name and a display name. It is possible to enter non-ASCII characters for both the internal name and the display name. (For example, on a Japanese client computer, it is possible to enter Japanese characters for these two names.) This works fine as long as the plant database is always accessed from client computers that are setup with the same locale. However, if the plant database is accessed from a client computer with a different locale setting, a failure might occur. (For example, using a client computer that is setup for American English to open a drawing in a plant that has had a Japanese property added will fail.) To avoid this potential failure, we recommend that all internal names for properties added through the Data Dictionary Manager are always entered using ASCII characters.

See Also

Add a Property to Database Tables

Modify Properties of Database Tables

Open Filter Manager

Open Format Manager