I have 6 records in a Sqlite3 database. Since it's my first steps, I decide to create a short example:
db = sqlite3.open('test.dbl')
The last rowid is undoubtedly 6, but I receive 0 as an answer.
So I decide to verify what Sqlite3 say. In the command line, I typed:
select last_insert_rowid() from contacts;
I got 6 zeros, one per each row. In the Sqlite3 interface, I inserted one record more. Imediately the answer was 7.
Well, if I insert a record with a Lua function, the rowid is not updated? If I insert a record with Sqlite, it does?
So, what is the code I used to insert values in this table?
local ins = db:prepare[[insert into contacts
values(:id, :date, :name, :phone, :mobile, :mail, :birthday, :note)]]
What I really want is to obtain, using Lsqlite3, the last rowid from this table:
create table contacts
id integer primary key not null,
entry date not null,
name text not null,
What I have done wrongly?