On 8 Mar 2011, at 2:58pm, Nico Williams wrote: > Gaps are OK for nextval, IIUC anyways, but normally they arise out of > write concurrency, which SQLite3 doesn't have. In any case, I would > recommend staying away from sqlite3_sequence and instead of doing > something more complete while still not necessarily going the distance > regarding syntax.
Yes. Is there any reason why you don't use your own sequences instead of relying on SQLite's functions ? You could simply use something like max(id)+1 . Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
