Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread V3 On Query Progress Quest
Thu, Oct 5 2006 7:08 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image