On 10 Mar 2011, at 7:57am, Mohd Radzi Ibrahim wrote: > So, that's explain why my column ID INTEGER PRIMARY KEY, changes when I use > REPLACE. I could not rely on the ID with this command.
Yes. You explicitly said 'REPLACE' so that's what it's doing. If you want to modify an existing record use the UPDATE command. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users