Hello Alexander,

I saw that Firebird always worked like this, but my question is:
Is this ok? is SQL standard?

Regards
Christian

--- In ib-support@yahoogroups.com, "Alexander V.Nevsky" <ded@h...>
wrote:

> --- 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.