2008/10/29 Shaun R. <[EMAIL PROTECTED]>: > The rowid looks to reuse numbers when a row is deleted, how can i stop this? > > For example, i insert 3 rows, then i delete row 2, when entering a new row > after that the rowid is 2 rather than 4. I want the rowid to be 4.
use AUTOINCREMENT keyword: CREATE TABLE tst( col1 INTEGER PRIMARY KEY AUTOINCREMENT ); > > ~Shaun > Rgds, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
