update Parameters set value =
(select value from WorkingParameters wp
where wp.id = Parameters.id);
Hi Igor,
That worked fine. I am curious why it does work? According to the
sqlite syntax guide, it says that...
"When a SELECT appears within an expression but is not the right
operand of an IN operator, then the first row of the result of the
SELECT becomes the value used in the expression. If the SELECT yields
more than one result row, all rows after the first are ignored."
I am not arguing with you, but I just wanted to be educated as to why
this way is correct. I am guess it has something to do with the WHERE
clause, since I tried something similar, but did not have the WHERE
clause specified. Thanks for the info.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
