returning the running status of a query

[gomond]

I am writing a small tool for one of our managers to delete some data from reporting tables.
The query runs for some time and the users become impatient.
Can I recieve the number of rows processed dynamically using the threaded query.
If so has anyone an example please.
I am quite new to Delphi and would welcome the help.

Thanks

Greg Omond

 

[gomond]

Dont worry I have decided to requery for the rowcount remaining.
I was just interested to see if this functionality was within the query VCL.

Thanks.

 

[gomond]

Dont worry I have decided to requery for the rowcount remaining.
I was just interested to see if this functionality was within the query VCL.

Thanks.

 

[Marco Kalter]

You cannot determine how many rows have been processed by a single delete statement while the statement is still running. This information will only be available after the delete is finished.

Only if you execute multiple delete statements you can determine how many rows have been processed through the RowsProcessed function after a delete statement is finished.

------------------
Marco Kalter
Allround Automations

 

[gomond]

Thanks Marco.
That is what I was doing, I was deleting in batches of 10000 rows and wanting the number of rows left in the table.
This was sitting in a do while loop.
I have since just requeried at the end of each pass and done the math.