Subject | Re: [IBO] Real Stumper of an error, Please help.--Resolution |
---|---|
Author | Chuck Belanger |
Post date | 2012-12-08T20:47:57Z |
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
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.