Re: [sqlite] Question of reusable rowid

Aha, AUTOINCREMENT ... Thanks a lot, Kevin > 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 recor

Re: [sqlite] Question of reusable rowid

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 i

[sqlite] Question of reusable rowid

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 som