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 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. I thought I was correctly following the sql syntax ... this was my reasoning, but I think I am misunderstanding something. sql-statement ::= UPDATE table-name SET assignment assignment ::= column-name = expr expr ::= database-name . table-name . column-name Could someone please help me with my query? Thanks, Rich Rattanni ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
