OLE-DB connector adapter properties

CachePeriod

The caching period (in seconds) for OLE-DB queries.

When this property is set to a value other than zero, the query result is cached to the specified amount of seconds. The default is zero and means no caching.

Note: You can clear the cache using the option in the adapter item context menu.

SelectCommand

The SQL statement or stored procedure that AVEVA™ Production Management uses to read the data provider.

This command has these sub-properties: CommandText, CommandTimeOut, and Parameters.

DeleteCommand

The SQL command that AVEVA Production Management uses to delete records in the data source.

InsertCommand

The SQL command that AVEVA Production Management uses to insert records in the data source.

UpdateCommand

The SQL command that AVEVA Production Management uses to update records in the data source.

CommandText

Defines the SQL statement for the dataset query. It must be defined for the OleDbAdapter item to communicate properly with the OLE DB provider and retrieve the requested dataset.

This property contains only one SQL query because each data adapter exchanges data between a single data-source table and a single data table in the resultant dataset.

If the dataset contains multiple data tables, the Update category commands update only the first table. The SQL statement can contain question marks (?) as parameter placeholders. The question marks are replaced at run-time in order by the elements of the parameters collection.

For insert and update commands, you can use the Build Update Commands option from the adapter's context menu to create the CommandText properties.

Note: This property is optional for InsertCommand and UpdateCommand properties.

A valid SQL statement

CommandTimeOut

The command timeout in seconds for the SQL statement.

Integers

Parameters

A set of parameters for the SQL statement.

Click Browse (...) to open the Collection Editor.

Valid SQL parameters