No, all consts or data from other column are put into expression before execution. Read http://www.sqlite.org/lang.html#update
-----Original Message----- From: Rubens Jr. [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 1:54 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] execution order of Update > > UPDATE command is evaluated before execution, so you can change a few fields > with one UPDATE. > > Best regards > Michal > Thanks for the fast reply !! But, may the update command evaluate in the inverse order ? In this case : First f2 wil receive value 'xxx', than f1 will receive value of f2 (now with xxx) !! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]