RE: [sqlite] Making a SEQUENCE?

2005-02-21 Thread Brown, Dave
the UPDATE + SELECT in C++ gives me back the next id properly :) Thanks for the help. -Dave -Original Message- From: Steve O'Hara [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 3:07 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Making a SEQUENCE? Hi Dave, Wrap your

RE: [sqlite] Making a SEQUENCE?

2005-02-21 Thread Steve O'Hara
uncommitted values from selects within the transaction. Steve -Original Message- From: Ulrik Petersen [mailto:[EMAIL PROTECTED] Sent: 21 February 2005 10:21 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Making a SEQUENCE? Hi Dave, Brown, Dave wrote: >I read that faq, but I d

RE: [sqlite] Making a SEQUENCE?

2005-02-21 Thread Brown, Dave
lse hasn't also incremented it further before I got to it. Do you see what I mean? -Dave -Original Message- From: Ulrik Petersen [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 12:49 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Making a SEQUENCE? Hi again, Brown,

Re: [sqlite] Making a SEQUENCE?

2005-02-21 Thread Ulrik Petersen
Hi again, Brown, Dave wrote: Is it possible to create the behaviour of a sequence with SQLite? I need to do something like this: [pseudocode] var id = SELECT next_val FROM my_sequence; INSERT INTO table1 VALUES(id, ...); INSERT INTO table2 VALUES(id, ...); I forgot to say that if you want to

Re: [sqlite] Making a SEQUENCE?

2005-02-21 Thread Ulrik Petersen
Hi Dave, Brown, Dave wrote: Is it possible to create the behaviour of a sequence with SQLite? I need to do something like this: [pseudocode] var id = SELECT next_val FROM my_sequence; INSERT INTO table1 VALUES(id, ...); INSERT INTO table2 VALUES(id, ...); This should return the next value, AND