Re: Sequences?

There is no relationship between MS Access's autonumbering and a SEQUENCE. The autonumering is part of the table and is only capable of sequential numbering. It has no flexibility, no programmability, and is strictly tied to a single table. All it is is the following code built in and hidden from the end user.

SELECT MAX(numbering_field)
INTO next_number
FROM xyz;

INSERT INTO xyz
(numbering_field + 1, other_field1, other_field2) VALUES
(next_number, someval1, someval2);

Daniel Morgan

Magnus Ytterstad wrote:

> 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 Wed Feb 13 2002 - 10:38:00 CST