Odd Errors returned

[Ruslan Zasukhin]

On 4/14/05 3:02 PM, "Chuck Neal" <chuck at mediamacros.com> wrote:

> How exactly does an "end of file" error translate to a database update?
>   What does that mean?  Is there a problem with executing hundreds of
> SQL commands in a repeat loop like this?  As mentioned it only does it
> on larger record sets.  I can take any number of smaller sub sets of
> this data and it works fine.

Chuck,

It sounds like a bug.

It should work for bug chunks also.

May be, make sure that you have periodically FLUSH in the loop.
For example, do flush for each 100 iterations.
IF this help them bug in the cache area.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]