> reasons. Can primary key values available because of deletes get re-
> used at some point?
I guess you're talking about rowids not about general primary keys.
For rowids reuse is possible only if rows with maximum values of
rowids are deleted and only if your INTEGER PRIMARY KEY column doesn't
Peter Haworth wrote:
>
> I have this question too. I'm not programming in C so don;t have
> access to the sqlite_last_insert_rowid
>
Yes you do. You just didn't realize it. Using the cmd line tool:
F:\sqlite>sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create
2 matches
Mail list logo