nal Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 12, 2004 5:19 AM
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] execution order of Update
>
>
> Rubens Jr. wrote:
> >
> > Is the update command executed in same order tha
Rubens Jr. wrote:
Is the update command executed in same order that was writen in the sql
command ?
example :
UPDATE t1 SET f1 = f2, f2 = '' WHERE
Is garanted that with this command f1 will have the value of f2 BEFORE f2
receive value xxx ?
I need to save the value of f2 than update f2,
>
> No, all consts or data from other column are put into expression before
> execution. Read
> http://www.sqlite.org/lang.html#update
>
>
I did not notice the " ...All expressions are evaluated before any
assignments are made.."
Thanks Again !
Rubens Jr.
---
Outgoing mail is certified Virus
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
>
> 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
> Is the update command executed in same order that was writen in the sql
command ? example : UPDATE t1 SET f1 = f2, f2 = '' WHERE Is
garanted that with > this command f1 will have the value of f2 BEFORE f2
receive value xxx ? I need to save the value of f2 than update f2, but I'm
not
Hi !
Is the update command executed in same order that was writen in the sql
command ?
example :
UPDATE t1 SET f1 = f2, f2 = '' WHERE
Is garanted that with this command f1 will have the value of f2 BEFORE f2
receive value xxx ?
I need to save the value of f2 than update f2, but
I'm not
7 matches
Mail list logo