RE: [sqlite] Re: Syntax help with UPDATE in SQLite Database Browser

2007-06-11 Thread Ellis Robin (Bundaberg)
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 ParameterV

[sqlite] Re: Syntax help with UPDATE in SQLite Database Browser

2007-06-08 Thread Igor Tandetnik
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.Netwo