Using CitectSCADA > Exchanging Data with Other Applications > Using ODBC drivers > Calling action queries with ODBC

Calling action queries with ODBC

Access ACTION queries cannot be called in a SELECT query such as:

"SELECT * FROM qdeDeleteRecipe"

To call an Access ACTION via ODBC, use the Call statement in SQLExec:

"{Call qdeDeleteRecipe}"

The statement needs to be enclosed in {curly} braces.

The Call statement can be used to Call SELECT queries, the resulting Recordset being accessible in the normal way.

See Also