Thanks Igor, the records in the Parameter table are required to ensure that the values returned from NewParams are matched to the appropriate records. By removing the referenecs to Parameter in the FROm statement I achieve 0 updates.
Thanks to all, I'll dump to another DB and do the work there. Rob -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Friday, 8 June 2007 9:56 PM To: SQLite Subject: [sqlite] Re: Syntax help with UPDATE in SQLite Database Browser Ellis Robin (Bundaberg) <[EMAIL PROTECTED]> wrote: > Update Parameter set ParameterValue = (select NewParams.parametervalue > from Scenario, Link, Catchment, FunctionalUnit, > FunctionalUnitDefinition, StandardFU, Parameter, NewParams where > Scenario.ScenarioID = 1004 and Scenario.NetworkID = Link.NetworkID and > Link.LinkID = Catchment.LinkID and FunctionalUnit.CatchmentID = > Catchment.CatchmentID and FunctionalUnit.FunctionalUnitDefinitionID = > FunctionalUnitDefinition.FunctionalUnitDefinitionID and > FunctionalUnit.FunctionalUnitID = StandardFU.StandardFUID and > StandardFU.RainfallRunoffModelID = Parameter.ModelID and > Catchment.Name = NewParams.Subcatchments and > FunctionalUnitDefinition.Name = NewParams.FU_name and > Parameter.Parameter = NewParams.parameter) Remove Parameter from the FROM clause of the subselect. You want to tie the subselect to Parameter table you are updating, rather than giving it its own. Igor Tandetnik ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ************************************************************************ The information in this email together with any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any form of review, disclosure, modification, distribution and/or publication of this email message is prohibited, unless as a necessary part of Departmental business. If you have received this message in error, you are asked to inform the sender as quickly as possible and delete this message and any copies of this message from your computer and/or your computer system network. ************************************************************************ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
