Async ADO INSERTs?

[JNeave]

Hi,

I'm trying to find out how to monitor the progress of a long (several hours at worst) INSERT query.

The (Test) Query

INSERT INTO TEST (bob) SELECT CaseID FROM Cases

The problem

Command.Execute( , , adAyncExcexute)

The VB thread continues fine, but the FetchProgress event does not fire. Probably because this is not fetch...

Does anybody know how you can monitor this?

Thanks!

James.

 

[CCLINT]

FetchProgress is a recordset event.
For an action query the provider doesn't notify the progress, or how much is complete, as with a recordset object which can determine how many records or to be fetched and then how many have already been retrieved.

Use the connection object and the ExecuteComplete event.
You will only know when the operation is completed then.