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.
Printable View
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.
This is something I'd like help with... but after almost four years, it's unlikely.
Oh well. Looks like looping then!
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).
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_p...sp?TID=60&PN=1