On 16 Apr 2012, at 7:11pm, Puneet Kishor <punk.k...@gmail.com> wrote:
> Thanks. That is one approach I have considered. I will try it out, but I am > less enthusiastic about it as it would involve creating a shadow table for > every table in the db. If you can summarise, instead of copying the columns individually, then you need only have one shadow table. Just make the table name a column in the shadow table. > I am planning to try both approaches, evaluate, and choose among them after > real experimentation. Another possibility would be to return to your own approach and simply have your software supply the values for new entries instead of making SQLite do it with AUTOINCREMENT. Before each INSERT just do BEGIN SELECT max(id)+1 FROM theTable INSERT ... END and supply the value returned from the SELECT in the INSERT command. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
