e.org
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.
U
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 wher
do retturn
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
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 sen
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 th
5 matches
Mail list logo