Re: [sqlite] sqlite-users Digest, Vol 23, Issue 26

2009-11-27 Thread Pavel Ivanov
> 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

Re: [sqlite] sqlite-users Digest, Vol 23, Issue 26

2009-11-26 Thread Gerry Snyder
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 tabl

Re: [sqlite] sqlite-users Digest, Vol 23, Issue 26

2009-11-26 Thread Peter Haworth
On Nov 26, 2009, at 4:00 AM, sqlite-users-requ...@sqlite.org wrote: > Message: 28 > Date: Thu, 26 Nov 2009 06:38:52 + > From: Simon Slavin > Subject: Re: [sqlite] Getting the rowid after an insert > To: General Discussion of SQLite Database > Message-ID: <643124a9-e4df-4287-a1bd-357126996.