Because UPDATE do not return a result set there is no any fetching events.
1. Kill TADOQuery - it for compatibility with BDE
Instead use TAdoDataset for SELECT only and TAdoConnection / TAdoCommand for
Realy you don't need in TAdoCommand, simply use function or procedure Execute
of TAdoConnection and set OnExecuteComplete for your Complete method.
If you decide use a TAdoCommand then call same method and anyway you must
assign OnExecuteComplete of TAdoConnection
Example see in Angus Robertson post.
About thread - you need if you want some Queries simultaneously or you must use
some TAdoConnection object - one for each query.
----- Original Message -----
From: "info2004" <[EMAIL PROTECTED]>
To: "ICS support mailing" <email@example.com>
Sent: Tuesday, May 06, 2008 9:13 AM
Subject: [twsocket] [OT] ADOQuery async operation
> I have posted to newsgroups.borland.com, but so far no joy. I am using some
> components in my project though;)
> The problem I have is getting the ADO stuff to work asynchronously.
> I am using a TADOQuery and have set ExecuteOptions to [eoAsyncExecute,
> eoAsyncFetch], and have set ADOQuery.OnFetchComplete := MyHandler.
> I have two ADOQueries, one doing a 'SELECT *', and another doing an 'UPDATE'.
> The select query fires it's OnFetchComplete, no problem. The update query
> not seem to fire anything.
> All of this happens in a thread, and the ADOConnection, ADOQuery are created
> the .Execute of the thread before my while (not Terminted) loop. All works as
> expected if I use sync calls, but I want to let other threads in whilst
> for the results.
> So, working on the assumption I have missed something, does anyone know of
> articles on using ADOQuery asynchronously? Google is not proving to be of
> so far.
To unsubscribe or change your settings for TWSocket mailing list
please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket
Visit our website at http://www.overbyte.be