Re: Autonumber an Oracle field with Access97 via odbc?

Lyle Homer wrote:
>
> I moved an access97 table onto an oracle 7 server and am able to
> get at and update the data via odbc, but the autonumber fields no
> longer work. (obviously, they're just number fields in the oracle
> table now)
>
> Is there anyway to make access control the numbering of this field
> when a new record is added? Is there such a thing as a
> psuedo-autonumber? How do I go about setting up something like this?
>
> Thanks for any reply,
>
> Lyle
> lhomer_at_xmission.com

Define a sequence generator and place a reference to it with -.nextval appended in the INSERT command:

INSERT INTO table (record_primary_id,...) VALUES (sequence.NEXTVAL,...)

Refer to CREATE SEQUENCE in your ORACLE documentation.

Gary Received on Tue Sep 09 1997 - 00:00:00 CEST