Re: Sequences?

From: Magnus Ytterstad <magnus.ytterstad_at_telia.com>
Date: Tue, 12 Feb 2002 21:30:07 GMT
Message-ID: <zPfa8.18091$n4.3132976@newsc.telia.net>

Not sure how MS Access autonumber works, but it does sound like a sequence to me.

To create a sequence use the following syntax

CREATE SEQUENCE MYSEQUENCE INCREMENT BY 1 START WITH 1000; When you want to access the sequence and get the next number, you just issue the command MYSEQUENCE.NEXTVAL, i.e.:

INSERT INTO MYTABLE (NAME, DEPT, ID)
VALUES ('John', 'Sales', MYSEQUENCE.NEXTVAL);

Hope this helps!
-magnus.

Bruce <bghagy_at_attbi.com> wrote in message news:gP3a8.39737$bh3.256829_at_rwcrnsc52.ops.asp.att.net...
> How would one go about implementing the MS Access autonmuber data type in
> 8i? Are sequences the way to go and could you point me in the right
> direction.
>
>
Received on Tue Feb 12 2002 - 15:30:07 CST