Denis:
Crystal clear now. Thanks a million!
--
Rich
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Rich Rattanni wrote:
I mean't when I tried this...
update Parameters set value = (select value from WorkingParameters wp);
When you execute this, it works, but it takes the first result row
from value and copies it into all the rows of parameters.
Rich,
When you execute an update statement,
What you tried made no sense. You can only use a table name in a
statement if it's the "primary" table of the statement (for UPDATE and
DELETE) or was explicitly introduced into the statement by FROM clause
(for SELECT). You can't just throw in any odd table, because you can't
then specify which r
Rich Rattanni <[EMAIL PROTECTED]> wrote:
update Parameters set value =
(select value from WorkingParameters wp
where wp.id = Parameters.id);
That worked fine. I am curious why it does work?
Why shouldn't it?
According to the
sqlite syntax guide, it says that...
"When a SELECT appe
4 matches
Mail list logo
