--- In ib-support@yahoogroups.com, "c_pradelli" <c_pradelli@y...>
wrote:

> Hello!
>
> I don't know if this is working as designed.
>
> if you execute and update:
>
> UPDATE MYTABLE SET FIELD1=FIELD1+1, FIELD2=(FIELD2+10)/(FIELD1+1)
>
> FIELD1=FIELD1+1 portion is done with the original value of FIELD1.
>
> but
>
> FIELD2=(FIELD2+10)/(FIELD1+1) portion is done with the new value of
> FIELD1 (FIELD1+1)
>
> is this ok?
> shouldn't be all UPDATE sentence with the original values of the
> fields?

Christian, I'm not sure about SQL standard, but I can say IB/FB
always worked this way.

Best regards, Alexander V.Nevsky.