Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 progress bar in SQL Shape command

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-24 : 21:45:49
douglas close writes "I have a form loaded from an SQL Select with Shape command. Takes a little while depending upon the size of the database. Would like to add a progress bar showing where it was in the load but haven't a clue as to how to make it happen. Have progress bars for record I/O where I am getting records in loops but no idea for how to perform in a Select statement using SQL or if I can. Any information would be appreciated."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-02-24 : 22:06:47
You might try checking the FetchProgress event. If you don't already have the ADO documentation, you can get it here:

http://www.microsoft.com/data/download.htm

Look for the MDAC SDK package, download and install it, and look for the ADO260.CHM help file, this contains all the information on ADO, SHAPE and FetchProgress.

Go to Top of Page
   

- Advertisement -