Re: Autonumber an Oracle field with Access97 via odbc?

Create a sequence in oracle ->CREATE SEQUENCE statement Create a before insert trigger for each row on the table to add the sequence number generated to the field in the table. -> CREATE TRIGGER statement
Inside the trigger body do a SELECT FROM <sequence name>.nextval into :new.<fieldname> FROM DUAL;

Matthew <xxx_at_xxx.xxx> wrote in article <01bcc96a$082833a0$020a0a0a_at_matthew>...
> Could you elaborate a little further? I'm pretty new at this.
>
> Matthew
>
> Arman Rawls <nospam_adrawls_at_stupp.com> wrote in article
> <01bcb9a9$2500eb00$e3010c0a_at_arawls>...
> >
> > Create a sequence for the table and have it enter the number in the
 insert
> > trigger.
> >
> >
>
>
Received on Fri Sep 26 1997 - 00:00:00 CEST