subject:"\[sqlite\] Update with nested selected"

Re: [sqlite] Update with nested selected

2012-08-15 Thread Igor Tandetnik

Steffen Mangold wrote: > I try to update a table field with a selected value from same tabel. Is this > possible? > What I try yet is: > update TableA Set FieldA = (select FieldB from TableA where IDField = > updateData.IDField AND TimeStamp = >

[sqlite] Update with nested selected

2012-08-15 Thread Steffen Mangold

Hi sqlite user, I try to update a table field with a selected value from same tabel. Is this possible? What I try yet is: update TableA Set FieldA = (select FieldB from TableA where IDField = updateData.IDField AND TimeStamp = date(updateData.TimeStamp, '-1 day')); I want to update the FieldA