I want to view the progress of a SQL select statement (made from VB) in a progress bar.
How can I do this?
First, issue the select statement as a SELECT COUNT() statement, to return the number of records which will match the actual select statement. Use this value in determining the percentage completion, later.
Next, you will have to open the recordset asynchronously.
Do an MSDN or Google search for ADO Asynchronous Recordset
Essentially, when using asynchronous recordsets, ado can return the number of records returned in an asynchronous event.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert