[SQL] Re: order of multiple assignments in UPDATE

2001-05-02 Thread Anuradha Ratnaweera
I understand that an UPDATE is done using "old" values of the variables involved so that we can write T(n + 1) = U(T(n)) where T(n) and T(n + 1) are the values of the table before and after update U. Thanks for all who pointed this out. Just as a matter of interest, I want to point out that t

[SQL] Re: order of multiple assignments in UPDATE

2001-04-29 Thread Ossie J. H. Moore
While I'm not sure specificly which order they will be determined in, it has no effect on what the value of "c1" will be. The value of "c1" will be 10 minus the value of "c2" where "c2" equals the value it was before the update occurred. For exmple... 1. Assume you create the following table...