Control on execution of query ???

[jovicat]

Parametrers :

-MS SQL, (or any other SQL MYSQL, DB, ORACLE, Posgress SQL..)
-ADO Connection + ADO Query
-Delphi 6.0.

Question : Is there a way to activate the query and to monitor the ecexution and progress of the query, and to cancel (user cancel) if it takes too long or there are some critical oprations going og the SQL Server.

P.S. J am looking for solution diferent from connection timeout like 30 or 60 seconds.

Tahnks,

 

[Griffyn]

TADOQuery has the OnFetchProgress event. Try adding code to that.

 

[jovicat]

Hi Griffyn !!!

Thanks for Your answer,

The FetchProgress just works with retreved data from server.
J'm actualy looking for controling the running of the query on the server. J read somewere that there are some functions 'callback' but in BDE and 'cbCANCELQRY' works only with Sybase.