Re: Emulating a sequence

David Pratt wrote:
> I was thinking about faking a sequence. My first thought was to
> create a sequence table with a single row where a field is a sequence 
> value and you just increment the value and retreive it as anything else. 
> It's simple but particulary good.


No comment as such on the sequence class (never
tried it myself). I just wanted to make sure
you did know about sqlite's automatic autoincrement
value. I know it's not the same as a sequence, but
in case you were simply trying to achieve the same
effect...

If you create a column which is

INTEGER NOT NULL PRIMARY KEY

then sqlite will automatically auto-increment
if you insert NULL (or don't insert):

<sqlite prompt code>
CREATE TABLE
   x
(
   id INTEGER NOT NULL PRIMARY KEY,
   code VARCHAR (10),
   name VARCHAR (60)
)
;


INSERT INTO x (code, name) VALUES ('BLAH', 'Blah');
INSERT INTO x (code, name) VALUES ('BLAH-2', 'Blah2');

SELECT * FROM x;

</code>

will result in:

1|BLAH|Blah
2|BLAH-2|Blah2

Just so you know.

TJG