Applies To
Connection object, Dynamic-Type Recordset object, Dynaset-Type Recordset object, Forward-Only-Type Recordset object, QueryDef object, Recordset object, Snapshot-Type Recordset object.
Description
Indicates whether or not an asynchronous operation (that is, a method called with the dbRunAsync option) has finished executing (ODBCDirect workspaces only).
Settings And Return Values
The return value is a Boolean that is True if the query is still executing, and False if the query has completed.
Remarks
Use the StillExecuting property to determine if the most recently called asynchronous Execute, MoveLast, OpenConnection, or OpenRecordset method (that is, a method executed with the dbRunAsync option) is complete. While the StillExecuting property is True, any returned object cannot be accessed.
The following table shows what method is evaluated when you use StillExecuting on a particular type of object.
If StillExecuting is used on
This asynchronous method is evaluated
Connection
Execute or OpenConnection
QueryDef
Execute
Recordset
MoveLast or OpenRecordset
Once the StillExecuting property on a Connection or Recordset object returns False, following the OpenConnection or OpenRecordset call that returns the associated Recordset or Connection object, the object can be referenced. So long as StillExecuting remains True, the object may not be referenced, other than to read the StillExecuting property. When you use the NextRecordset method to complete processing of a Recordset, the StillExecuting property is reset to True while subsequent result sets are retrieved.
Use the Cancel method to terminate execution of a task in progress.
See Also
Cancel method, Execute method, MoveFirst, MoveLast, MoveNext, MovePrevious methods, OpenConnection method, OpenRecordset method.
Example
See the Cancel method example.