Dynamic Tables Configuration Category

The Dynamic Tables Configuration Category is used create and maintain the definitions of tables that can be placed on AVEVA P&ID drawings.

The application pane is divided into the following sections.

Existing Tables Section

This section lists the dynamic tables previously created.

To edit a table, select it from the list. Its details are then displayed in the other sections and may be amended as necessary.

To delete a table, select it from the list and click Delete.

A message is then displayed requesting that the user confirm that the deletion is to take place. Click Yes to continue.

Tables Details - Buttons Section

These buttons are used to create new tables and amend existing ones.

To create a new table, enter its name in the Table Name field, and click Add. The table is then added to the Existing Tables list.

Enter details of the table in the Table Details fields, and specify the columns to include in the table using the grid in the lower half of the screen (and use the Update button to save these settings).

To save changes to a table, click Update.

To clear all details of a table (without deleting it), click Clear.

Tables Details - General Settings Section

Enter the name of the table in the Table Name field.

From the Database Name list, select the database from which the table data is to be extracted (for example, the project database).

From the Stored Procedure list, select the stored procedure (e.g. the database table) from which the table data is to be extracted.

The button adjacent to the Colour field is used to select the colour of the table (for example, of its borders and text). On selection of the button, the colour selection dialog is displayed:

The Colour Code can be selected by the following methods:

• Selection of one of the colours shown in the palette

• By double-clicking on the Assume By Layer hyperlink. Items will automatically assume the colours of the layers they are inserted into, as set in the Layers Sub-Category the Drawing Configuration Category.

• By manually entering the Colour Code field

The Assume Owner Colour option is not applicable in this case and will set the colour to the default value. Following selection, press OK. The selected colour code will then be displayed in the Colour field.

In the X and Y fields, enter the coordinates that the table will be placed at in drawings (if not placed manually). The insertion point of tables are their bottom left-hand corners.

In the Text Style field, select the style to be used for the text of the table. Text styles are defined using the Text Styles Configuration Category. By default, the ROMANS style is used, which is supplied with the application.

In the Layer field, select the drawing layer that the table will be placed on. Layers are defined using the Layers Sub-Category of the Drawing Configuration Category.

The button adjacent to the Colour for Modified Annotation field is used to select the colour that the application uses to highlight any changes made to table data after insertion. It displays the colour selection dialog as described above for the Colour field. After the required colour is selected using this dialog, the colour code is then displayed in the Colour for Modified Annotation field.

From the Layout field list, select the orientation of the table layout, either vertical or horizontal. If vertical is selected, data will be placed column by column. If horizontal is selected, it will be placed row by row.

In the Horizontal Margin and Vertical Margin fields, enter the margins for text inside the table cells, for example, the space between text and the cell borders.

Note: These margins must be less than the row height of the table and column headers. An error message is displayed if this is not the case.

Check the Show Object without Tag Annotation checkbox if table data is to be displayed without the accompanying labels. By default, this checkbox is unchecked.

Tables Details - Table Header Settings Section

If the table is to include a header, make sure that the Show Table Header checkbox is checked (it is by default).

Specify details of the table header using the Row Height, Text Height and Text Align fields.

Note: The text height must be less than the row height. An error message is displayed if this is not the case.

Tables Details - Column Header Settings Section

If the table columns are to include headers, make sure that the Show Column Header checkbox is checked (it is by default).

Specify details of the column headers using the Row Height, Row Width, Text Align and Text Height fields.

Note: The text height must be less than the row height. An error message is displayed if this is not the case.

Note: The Row Width setting is used as the default width for table columns. It can be overridden for individual columns by setting Column Width values in the grid.

Tables Details - Data Settings Section

Specify details of the table data using the Text Height and Text Align fields.

Columns Section

The data to be included in a table is specified by selecting columns from the database in the grid in the lower half of the screen.

To add columns to a table, click . The Add Column Info dialog is then displayed:

The dialog lists the columns derived from the procedure (database table) selected in the General Settings section. To select a column check its checkbox. Multiple columns can be selected. Check the Select All checkbox to check all the checkboxes.

Once the required columns have been selected, click OK to add them to the table definition. They are then added to the grid.

In the grid, the Column Name fields displays the names of the table columns. These cannot be edited.

The Alias fields displays the names that will be displayed in column headers when the table is placed on drawings. These initially default to the column names but can be changed as required.

If required, enter the width of columns in the Column Width fields. If a width is not specified for a column here, it will use the Row Width setting instead (see above).

The order in which columns are listed in the grid controls the order in which they are displayed when placed on a drawing. To change the order of columns in the table, use the and buttons.

To delete a column from the table, click .

Automatic Refresh Section

Data in dynamic tables may be automatically updated in drawings when the following takes place:

• When a drawing is opened or otherwise activated.

• When a drawing is consolidated (during synchronization or otherwise).

• When a drawing is updated from the database.

If this is required (for all tables), check the Automatic Refresh Tables checkbox. The checkbox is unchecked by default.

Note: This facility only updates the data in dynamic tables. It does not update the format and appearance of dynamic tables (colours, row heights and so on).