Displaying 1 result from an estimated 1 matches for "last_insert_rowid".
2012 Feb 21
1
sqlite create new unique id
Hi everyone,
I am trying to insert a row in sqlite table with my own unique id. I want
to create unique id using sqlite internal function
last_insert_rowid() which returns the next max rowid of the table which is
always unique. I tested this using sqlite and it works fine but when i run
the same query using RSQlite from r prompt, my query doesn't create new
unique id.
last_insert_rowid() always returns 0 value from RSQLite always returns 0.
How...