Silven,

<< I seem to be getting the error when the function has completed the 3500
enties and has returned to the calling procedure >>

Can you run the code in the IDE debugger and see what it fails ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Silven,

<< Is there away to get the number records inserted when using the INSERT
INTO method. >>

As Roy indicated - use the RowsAffected property.

<< I also implemented  a progress bar on the  OnQueryProgress is it normal
for the below query to progress from 0 to 100 twice. >>

It's executing once for one of the sub-select queries, and once for the
actual insert.   Probably one of the sub-select queries can be executed live
(no progress bar since it is instantaneous) while the other one has to
generate a canned result set (progress bar).

--
Tim Young
Elevate Software
www.elevatesoft.com

---Can you run the code in the IDE debugger and see what it fails ?
---generate a canned result set (progress bar).


Tim I am not sure why my previous post did not make it to the boards but the program seems to crash right after I step out of the function back into the calling procedure.

If I put a break point on my the last free table statement and step back to the calling procedure the bug will occur when the calling procedure does a ShowMessage of the result returned by
the function, the showmessage does not show my set statement instead I get the 9494 error

Thanks for all your help,
silven

Silven,

<< Tim I am not sure why my previous post did not make it to the boards but
the program seems to crash right after I step out of the function back into
the calling procedure.

If I put a break point on my the last free table statement and step back to
the calling procedure the bug will occur when the calling procedure does a
ShowMessage of the result returned by the function, the showmessage does not
show my set statement instead I get the 9494 error >>

That doesn't sound right at all - it should stop right on the calling
statement that experiences the error.

--
Tim Young
Elevate Software
www.elevatesoft.com

I just tried it again and it does not crash on the line of code it will enter all 3524 entries.

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Silven,

<< Tim I am not sure why my previous post did not make it to the boards but
the program seems to crash right after I step out of the function back into
the calling procedure.

If I put a break point on my the last free table statement and step back to
the calling procedure the bug will occur when the calling procedure does a
ShowMessage of the result returned by the function, the showmessage does not
show my set statement instead I get the 9494 error >>

That doesn't sound right at all - it should stop right on the calling
statement that experiences the error.

--
Tim Young
Elevate Software
www.elevatesoft.com