How to implement Progress bar in SQL statement ? [Archive]

Click to See Complete Forum and Search --> : How to implement Progress bar in SQL statement ?

vicky

Jul 28th, 1999, 08:14 AM

i generate query using SQL statement. It like this:
sSql$ = "INSERT INTO tTempExpSys(CustName) "
"SELECT CustName FROM tCust"
db.execute sql$

how do i implement the progress bar and integrate into this SQl statement ?

Please help.

stevebmartin

Jan 19th, 2004, 04:34 AM

This is something I'd like help with... but after almost four years, it's unlikely.

Oh well. Looks like looping then!

si_the_geek

Jan 19th, 2004, 06:20 AM

yep, I'm afraid for this kind of thing looping is the only way.

the only alternative is that you run some sort of stored procedure that can return the percentage done during the process (which would effectively be a loop anyway).

Mike Collier

Jan 19th, 2004, 02:35 PM

Is this via ADO, if so you could try asynchronous execution of the recordset.

Some details here but not complete:

http://81.130.213.94/myforum/forum_posts.asp?TID=60&PN=1