Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Thu, Oct 5 2006 7:08 PM	Permanent Link
David Ray	While using ExecSQL, OnQueryProgress seems to be working fine except when a DELETE is executing (I have a SELECT, a DELETE, and another SELECT, and the two selects seem to fire OnQueryProgress, but the delete doesn't). Is that the way it is or am I overlooking something? Thanks, in advance... David
Fri, Oct 6 2006 4:11 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	David, << While using ExecSQL, OnQueryProgress seems to be working fine except when a DELETE is executing (I have a SELECT, a DELETE, and another SELECT, and the two selects seem to fire OnQueryProgress, but the delete doesn't). Is that the way it is or am I overlooking something? >> What specific version of 3.x are you using ? Is the DELETE actually able to delete anything ? Also, is all of this being run in one script, or separately statement by statement ? -- Tim Young Elevate Software www.elevatesoft.com
Fri, Oct 6 2006 5:15 PM	Permanent Link
David Ray	Tim Young [Elevate Software] wrote: > David, > > << While using ExecSQL, OnQueryProgress seems to be working fine except when > a DELETE is executing (I have a SELECT, a DELETE, and another SELECT, and > the two selects seem to fire OnQueryProgress, but the delete doesn't). > > Is that the way it is or am I overlooking something? >> > > What specific version of 3.x are you using ? Is the DELETE actually able to > delete anything ? Also, is all of this being run in one script, or > separately statement by statement ? > Tim, This is V3.20. It is entirely possible nothing is being deleted in most instances -- perhaps the progress bar only reflects actual deletes and not the processing on the table... These are 3 separate statements each terminated with a ";" and run with ExecSQL in a single script. This isn't a huge problem, I was just trying to figure out why my progress bar acts a little strangely. Thanks... David
Mon, Oct 9 2006 2:03 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	David, << This is V3.20. It is entirely possible nothing is being deleted in most instances -- perhaps the progress bar only reflects actual deletes and not the processing on the table... >> Most likely you are correct. I have to guess at the moment because the 3.20 versions are all on backups here. -- Tim Young Elevate Software www.elevatesoft.com