http://www.sqlite.org/autoinc.html
Rgds, Simon 2008/6/13 Kang Kai <[EMAIL PROTECTED]>: > Hi, > > In an application I use the default 'rowid' column as identifier of objects > stored in table. > > I found that if I delete the record that has the maximal rowid, the rowid > will be reused when I insert a new record. > > This mechanism may cause mismatched data in my application because there're > some cross-table information and I don't wanna update related tables > everytime. > > For example, table A stores the user list of my app, table B stores user > operation logs. I think it's improper to delete all the related logs in B > generated by a user when the user is removed in A. > > I know some ways to resolve this problem such as adding a 'deleted' flag > column to the user table, or implement a custom 'rowid' column that rowid > can't be reused. I'm just curious to know if sqlite can do this by its native > functionality? I've glanced the source code of sqlite3 but found nothing > helpful. > > -- > Regards, > Kevin Kang > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
