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

2007-06-07 Thread Ellis Robin (Bundaberg)
Subject: Re: [sqlite] Syntax help with UPDATE in SQLite Database Browser Maybe you really have to loop "outside" sqlite to align the rows & values. From the result you got and the UPDATE documentation, I can guess that the subselect in the assignment is flattened to a scalar. Unfort

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

2007-06-07 Thread miguel manese
Maybe you really have to loop "outside" sqlite to align the rows & values. From the result you got and the UPDATE documentation, I can guess that the subselect in the assignment is flattened to a scalar. Unfortunately sqlite does not have something like update tbl1 set col=tbl2.col from tbl2

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

2007-06-07 Thread Ellis Robin (Bundaberg)
valid records. Any more hints? Rob -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, 8 June 2007 2:48 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Syntax help with UPDATE in SQLite Database Browser You don't seem to be positioning on a row

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

2007-06-07 Thread John Stanton
You don't seem to be positioning on a row in the Parameter table with a WHERE clause. Ellis Robin (Bundaberg) wrote: Could I please get some help on the syntax required to perform my UPDATE based on a selection from multiple tables? I've been through the archives but can't seem to make much

[sqlite] Syntax help with UPDATE in SQLite Database Browser

2007-06-07 Thread Ellis Robin (Bundaberg)
Could I please get some help on the syntax required to perform my UPDATE based on a selection from multiple tables? I've been through the archives but can't seem to make much sense of the examples given. I have a table containing 'new' paramater values, I need to update the relevant records in