Subject Re: [IBO] Real Stumper of an error, Please help.--Resolution
Author Chuck Belanger
Hello:

The take away from this error is that it is better to avoid using:
IB_Query.fetch dataset
While not EOF
Edit
Field1 := Field2
Post

Instead:
IB_Cursor.Fetch
While not EOF
DSQL.Update

This can avoid these strange problems. Also, I learned by looking at the
IB_Monitor that a POST is treated by FireBird as an UPDATE, but ALL the
columns are included, even if the Fields being assigned in Edit were
limited.

I want to give special thanks to Thomas for his allowing me to use his
FB Trace Manager, full license (short term), so we could trace this
problem.

Thanks, again Jason for a great component set in IBObjects!

Chuck
> Jason:
>
> I wanted to give an update on this series of issues.
>
> This issue seems to be about using IB_Query or IBOQuery within a While
> not EOF loop and in that loop there is an Edit, Field1.value :=
> Field2.Value; then POST.