Re: [sqlite] Re: One statement column to column copy

2007-04-19 Thread Rich Rattanni
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

[sqlite] Re: One statement column to column copy

2007-04-19 Thread Igor Tandetnik
Rich Rattanni <[EMAIL PROTECTED]> wrote: I have a main table (Parameters) which contains system parameters to which I clone the table to a temporary database... CREATE TEMPORARY TABLE WorkingParameters AS SELECT * from Parameters; I modify the parameters in the temporary table, and occasional

[sqlite] Re: One statement column to column copy

2007-04-19 Thread Rich Rattanni
On 4/19/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: All: I have a main table (Parameters) which contains system parameters to which I clone the table to a temporary database... CREATE TEMPORARY TABLE WorkingParameters AS SELECT * from Parameters; I modify the parameters in the temporary tabl