Progress Bar While SQL Stored Procedure Executing
Posted on 2000-03-01
I am using D5 and MSSQL7 and have some database update stored procedures which take a little while to execute. To give the user a progress bar, I figure I could maintain a small table in the database which has a progress count (or percent). To access this progress table, the application could perhaps use a timer to fire off a query to read progress information (to feed to the progress bar). Is seems that I would have to establish a seperate Thread in which the query to read progress is executed. Is this the correct approach? Has anyone done this who could assist?