[Date Prev][Date Next][Thread Prev][Thread Next]
[Date Index]
[Thread Index]
- Subject: Re: Error with Lsqlite3
- From: Doug Currie <doug.currie@...>
- Date: Wed, 2 Jun 2010 20:08:39 -0400
On Jun 2, 2010, at 7:47 PM, Luciano de Souza wrote:
> db = sqlite3.open('test.dbl')
>
> print(db:last_insert_rowid())
>
> The last rowid is undoubtedly 6, but I receive 0 as an answer.
>From http://www.sqlite.org/c3ref/last_insert_rowid.html
> This routine returns the rowid of the most recent successful INSERT into the database from the database connection in the first argument. If no successful INSERTs have ever occurred on that database connection, zero is returned.
Since db (the database connection) was just opened, 0 is the expected answer.
Perhaps you should try executing the query: select max(id) from contacts;
e
