Probably this isn't the cause of your problem, but.. why are you using your own id field? SQLite provides rowid which does autoincrement automatically. I read a page from the SQLite developers, where they discourage use of AUTO_INCREMENT.
Novice
Re: SQLite misbehaving
Probably this isn't the cause of your problem, but.. why are you using your own id field? SQLite provides rowid which does autoincrement automatically. I read a page from the SQLite developers, where they discourage use of AUTO_INCREMENT.
Intermediate user
Re: SQLite misbehaving
Are you sure that it is lost? Using the command line and browsing the table shows no entries?
Posting Permissions
Reply With Quote
Bookmarks