Re: [R] sqlite create new unique id

2012-02-22 Thread Jadhav, Alok
, February 22, 2012 9:08 PM To: Jadhav, Alok; r-help@r-project.org Cc: Rory Arneil; Jakub Barszczewski Subject: RE: [R] sqlite create new unique id Hi Alok Yes, last_insert_rowid() will always look for the last row inserted in this connection, so you will always get 0 before inserting a new row in a

Re: [R] sqlite create new unique id

2012-02-22 Thread Chris Campbell
: RE: [R] sqlite create new unique id Hi Chris, Apologies for getting back late. In my case I am creating a new connection everytime I insert a new trade. I thought last_insert_rowid() would insert max(rowid) for given table? I can try to insert bunch of rows in a data frame, but whenever I

Re: [R] sqlite create new unique id

2012-02-21 Thread Jadhav, Alok
t.org Cc: Rory Arneil; Jakub Barszczewski Subject: RE: [R] sqlite create new unique id Hi Alok Are you certain that you are keeping your connection open? last_insert_rowid() returns id of last inserted row from the current database connection (which invoked the function). Is it possible that every

Re: [R] sqlite create new unique id

2012-02-21 Thread Chris Campbell
Campbell MANGO SOLUTIONS Data Analysis that Delivers +44 1249 767700 -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Alok Jadhav Sent: 21 February 2012 06:59 To: r-help@r-project.org Subject: [R] sqlite create new unique id Hi everyone

[R] sqlite create new unique id

2012-02-20 Thread Alok Jadhav
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