On 7 Apr 2010, at 10:06pm, P Kishor wrote: > On Wed, Apr 7, 2010 at 3:46 PM, Pavel Ivanov <[email protected]> wrote: >> Probably the only way to do that is >> >> REPLACE INTO t (id, foo, bar, ...) >> SELECT 649, foo, bar, ... >> WHERE id = 651 >> > > I get a "Error: constraint failed". I have no constraint other than > INTEGER PRIMARY KEY on id.
I hope that you don't already have a record with id = 651. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
