search for: primaryidtable

Displaying 1 result from an estimated 1 matches for "primaryidtable".

Did you mean: primary_table
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 these...