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
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
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,
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
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
5 matches
Mail list logo