Re: [sqlite] using auto increment in java

2006-11-14 Thread Mario Frasca
On 11/11/2006 10:16 PM, Will Leshner wrote: You should be able to get the last inserted rowid using the last_insert_rowid() function in a query: SELECT last_insert_rowid(); sorry for the slow reaction, but I had to check my own code first... On Fri, 28 Jul 2006 16:47:21 +0200, Nemanja Corlij

Re: [sqlite] using auto increment in java

2006-11-11 Thread Will Leshner
On 11/11/06, Patrick Marchwiak <[EMAIL PROTECTED]> wrote: I am working on a Java program that uses SQLite for its database. I am using auto increment on some of my inserts and am wondering if there is some easy way to retrieve the auto incremented rowid right after inserting. I realize that there

Re: [sqlite] using auto increment in java

2006-11-11 Thread David Crawshaw
On 12/11/06, Patrick Marchwiak <[EMAIL PROTECTED]> wrote: I am working on a Java program that uses SQLite for its database. I am using auto increment on some of my inserts and am wondering if there is some easy way to retrieve the auto incremented rowid right after inserting. I realize that there