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 occasionally I may
want to save them. Reading the sqlite documentation, I thought I
would be valid to execute
UPDATE Parameters SET value = temp.WorkingParameters.value; But I get
an error stating that temp.workingparameters.value does not exist.
Do you have any kind of unique id in Parameters table? How do you plan
to match a row in WorkingParameters to a corresponding row in
Parameters? Assuming you do:
update Parameters set value =
(select value from WorkingParameters wp
where wp.id = Parameters.id);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
