Why doesn't AUTOINCREMENT work like rowid, in that, with rowid if the value on insert is not null it doesn't get a new rowid, it just accepts the value as in the insert?
Im trying to develop a win phone app in that data downloaded from the server needs to insert as it comes, but rows added on the phone need to use AUTOINCREMENT, in which case the id is null and the db has to get the next rowid? One can do something similar on sql server by setting identity_insert on. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
