How to show the elapsed time while a long SQL Query is executed?

Posted by Salvador on Stack Overflow See other posts from Stack Overflow or by Salvador
Published on 2010-03-26T21:11:17Z Indexed on 2010/03/27 11:33 UTC
Read the original article Hit count: 315

Filed under:
|

i need to show a popup window before the a query execution, show the time elapsed while the sql query is executed , and close that windows when the query ends.

actually i do something like this

var
frm : tFrmPopupElapsed;
// this form have a ttimer and a tlabel to show the elapsed time
//but the tlabel is not updated, i tried using update; and refresh; but nothing happens
//the timer is enabled.
begin
 frm:=tform.create(nil);
 frm.Init;//this procedure set the timer to enabled:=true
try
 frm.Show();
 ExecuteMyVeryLongQuery();
finally
 frm.Close; 
end;

end;

wich is the best way using a ttimer? a Tthread ?

thanks in advance.

© Stack Overflow or respective owner

Related posts about delphi

Related posts about delphi-7