Map InTouch tags to database columns

You can map InTouch Tags to database columns. This is done with a Bind List. Most SQL Access functions use the Bind List to enable InTouch tags to access data in SQL database tables.

A Bind List associates database table columns to tags in the InTouch Tagname Dictionary. A Bind List also includes a Table Template that describes the format of the database tables.

When you run a script containing the SQLInsert(), SQLSelect() or SQLUpdate() functions, the Bind List is updated to specify which InTouch tags are used and which table columns are associated with these tags.

Create a new Bind List

1. In the Tools pane, expand SQL Access Manager, and select Bind List.

   A message to confirm the creation of the SQL.DEF file appears.

2. Select Yes to create the SQL.DEF file.

   The Select a Bind List dialog box appears.

3. Select New.

   The Bind List Configuration dialog box appears.

   

4. In the Bind List Name box, type the Bind List Name.

   A Bind List name can be up to 32 characters.

5. To define the tags for the Bind List, do one of the following:

   • In the Tagname.FieldName box, type an InTouch tag name. You can also add an optional tag dotfield in the form tag_name.dotfield_name.

   • Double-select Tagname to select an existing tag. The Select Tag dialog box appears. Select a tag from the list.

     Note: I/O type tags that are not used in your application, but are specified in a SQL Access Bind List, are activated (advised to the DAServer) as soon as WindowViewer starts.

6. Select the dotfield to append to the tag by one of the following:

   • In the Tagname.FieldName box, type a period and the dotfield name after the tag name

   • Select FieldName. The Choose field name dialog box appears. Select the dotfield that you want to append to the tag.

7. In the Column Name box, type the name of the column.

   A column name can be up to 30 characters in length. If the column name has a space, use square brackets around the column name in the Bind List and when used in a script. For example:

   WHERE EXPR= "[Valve ID] = " + text (tagname,"#");

8. Position the tag within the Bind List by doing one of the following:

   • Select Move Up to move the selected tag up one level in the list.

   • Select Move Down to move the selected tag down one level in the list.

9. Select Add Item to add your new Tagname.FieldName and Column Name to the Bind List.

10. Select OK to save your new Bind List configuration and close the dialog box.