Adding Rows to the Table

You can now enter the rows that tell SQL Direct Configuration where to get the data from. Select the table name and then select Insert>Row or click on the toolbar.

A drop-down list will appear under the "Rows of" column in the right-hand pane. Click on the down-arrow and select an element type from the list. PDMS Provider locates all elements of this type when it retrieves data.

If you labelled any columns with the exact name of an element attribute, e.g. "REFNO", Table Designer fills in the attribute for you; Table Designer assumes if the name of a column matches an attribute name, then that is the attribute you want.

If there are any entries along your row under the headings marked "unset", then you need to tell Table Designer which attribute provides the data for that column, i.e. you need to set the binding for that column. Double click on the word "unset" and select the attribute you want from the drop-down list. The list contains all the attributes for the type listed in that row.

Having selected an attribute for an "unset" (or changed one that Table Designer put in by default), Table Designer will attempt to re-use that attribute in any subsequent rows you may add. In other words, it looks at the bindings for the row immediately above the new row when choosing defaults, and uses the column names for the first row. It is quicker therefore, to get the first row exactly right, then add new rows, rather than add all the rows before checking the bindings.

Repeat from Inserting and Naming a New Table to create all the tables that you need.

To save the table you just defined as a .tsf file, select File>Save, or File>Save As¼, or click on the toolbar.