I am trying to get a handle on sqlite and adapt from my MS SQL knowledge and having trouble...
When I do this..
insert into tblRecords2(myField) values ('A7962144F9C16EE22672D96C6655063');
The select last_insert_rowid(); returns 0 - but this is not true because i can select rowid from tblRecords2 and get the new value.
Can anyone tell me why this is?
I am testing on Windows machine using RazorSQL.