Editing the ODBC tables

Before you begin

It is recommended to read the following Help topics before editing the ODBC tables:

Read the table overview to understand how the tables are linked together
Read the table descriptions to understand the specific rules that apply to each table

General editing rules

Observe the following editing rules:

To avoid any conflict between the Definition program and the ODBC tables, close the Definition program before editing the tables.
If you make changes in the Definition program while the ODBC tables are open, you must close the database and reopen it to view the new changes.
If you make changes in the ODBC tables while the Definition program is open, you will be warned about these changes when you switch back to the Definition program. The dialog box below will appear. Note that you will lose any unsaved changes in the Definition program, if you do this.

$images\def_chg.gif$

Editing a single table

You can edit each table individually by simply double-clicking it in the database window and then changing the properties, as required.

However, in many cases you want to edit properties from multiple tables. See the description below.

Using queries to extract data

Let us take an example where we extract data from two tables. We want to edit the object properties contained in the SUPERCONF and ATOM tables for all objects in the configuration.

In the database window, click the Queries tab and click New.
Double-click Design View to design the query. The Show Table dialog box appears.

$images\query_show.gif$

Select the SUPERCONF and ATOM tables and click Add. The tables are shown above the design grid.
Close the Show Table dialog box.
Link the primary key fields by dragging a line from AREA in the SUPERCONF table to AREA in the ATOM table and do the same with the ENAME field.

$images\query_link.gif$

Drag the fields from the SUPERCONF and ATOM tables that we want to view or edit to the design grid.
In this example:

SUPERCONF table = AREA, ENAME, DRIVERID and NODE_NUMBER

ATOM table = ATOMID, DATAGROUP, WORD OFFSET and BIT OFFSET

$images\query_design.gif$

Run the query by clicking $images\ico_run.gif$ . The extracted fields appear.

$images\query_finish.gif$

Edit the properties, as required.

You may, for example, make an update query if you want to change the node number for a number of objects.