Add OLE-DB parameters

You can add a collection of parameters to the SQL statements that you write in the CommandText sub-property of the SelectCommand, DeleteCommand, InsertCommand, and UpdateCommand properties.

If a SQL statement contains question marks (?) as parameter placeholders, AVEVA™ Production Management replaces the question marks at run-time with the parameters. AVEVA™ Production Management replaces the question marks with parameters according to the order of the parameters in the Parameter Collection Editor; that is, the first parameter replaces the first question mark in the SQL statement, the second parameter replaces the second question mark in the SQL statement, and so on.

To add an OLE-DB parameter

1. In the Parameters property of the SQL statement for which you want to add parameters, click Browse (...). The Parameter Collection Editor appears:

   

2. Click Add to add a parameter to the collection.

3. Select a parameter and then click Move Up or Move Down to rearrange the sequence of parameters in the Members list.

4. Select the parameter in the Members list and then edit the values in the right column of the Parameter Properties grid to set the parameter properties.

5. Click OK.

Related topics

• List of OLE-DB parameter properties

• Add and configure an OLE-DB data source

• Add and configure an OLE-DB data connection

• Add and configure an OLE-DB adapter