Displaying 1 result from an estimated 1 matches for "primaryidt".
Did you mean:
primaryid
2012 Feb 21
1
sqlite create new unique id
...is 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 can I get a unique id using RSQLite ?
my query looks like this
"insert into PrimaryIdTable values ('AMP AT
Equity','bbg','2001-01-01','2099-01-01','P'||last_insert_rowid())"
reason i am not using INTEGER PRIMARY KEY is because i want to keep my key
as TEXT datatype. This is because another table has same field for secondary
id and both t...