Navigation:  DAO Object Classes > DaoQueryDef Class > DaoQueryDef:Execute() Method

Purpose

Execute the Querydef (must be non-row returning)

 

Parameters

 

Returns

NIL

 

Remarks

The Execute method is valid only for action queries. If you use Execute with another type of query, an error occurs. Because an action query doesn't return any records, Execute doesn't return a Recordset. (Executing an SQL pass-through query in an ODBCDirect workspace will not return an error if a Recordset isn't returned.)

 

Use the RecordsAffected

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

property of the QueryDef object to determine the number of records affected by the most recent Execute method. For example, RecordsAffected contains the number of records deleted, updated, or inserted when executing an action query.

 

In an ODBCDirect workspace, if you include the optional dbRunAsync constant, the query runs asynchronously. To determine whether an asynchronous query is still executing, check the value of the StillExecuting property on the object from which the Execute method was called. To terminate execution of an asynchronous Execute method call, use the Cancel method.

 

You can use the following constants for IOptions:

 

 

 

Class