Configure the SQL server string delimiter in Bind Lists

The SQLInsert() and the SQLUpdate() functions use a default format that encloses message strings within single quotation marks. Some SQL databases expect to receive message strings enclosed by another type of delimiter. For example, Oracle 8.0 expects to receive a date string surrounded by brackets. When this occurs, the Delim() function must be used.

In the Bind List Configuration dialog box Column Name field, after the column name, use the delim() function. The keyword "delim" must be entered followed by:

• a left parenthesis

• the left delimiter

• the list separator character defined in the system’s regional settings

• the right delimiter

• a right parenthesis

Example for an English system: datestring delim (',')

Example for a German system: datestring delim (';')

To use the same delimiter for both left and right, specify the delimiter in parentheses without the separator, as shown in the following example:

datestring delim (' ')

Modify a 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 the Bind List name that you want to change, and then select Modify.

   The Bind List Configuration dialog box appears.

   

4. Modify the required items.

5. Select OK to save your changes and close the dialog box.

Modify a Bind List with Excel

SQL Access Manager saves the configuration information for the Bind Lists and table templates to the SQL.DEF file. This file is formatted as a Comma Separated Value (CSV) file.

The SQL.DEF file can be modified with any product that supports Comma Separated Value files like Excel.

The data appears in the file as follows:

:BindListName, BindListName

Tagname1.FieldName,ColumnName1

Tagname2.FieldName,ColumnName2

Tagname3.FieldName,ColumnName3

:TableTemplateName, TableTemplateName

ColumnName1,ColumnType,[ColumnLength],Null,Index

ColumnName2,ColumnType,[ColumnLength],Null,Index

ColumnName3,ColumnType,[ColumnLength],Null,Index

Delete a Bind List

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

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

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

   The Select a Bind List dialog box appears.

8. Select the Bind List name that you want to delete.

9. Select Delete. A message appears requesting confirmation to delete the Bind List.

10. Select Yes to delete the selected Bind List.