Re: Autonumber

From: Sree Ghantasala <sree_at_bellsouth.net>
Date: Sat, 11 Apr 1998 23:41:31 GMT
Message-ID: <LcTX.1809$Be.2393517@news1.atl.bellsouth.net>

>When I try and enter data into the Testdata field using ODBC via MS access
>linked tables, I get an error message that says that testID cannot be null.
>
>Why doesn't oracle create a unique number here?
>
>

Oracle does not automaticall generate unique numbers! You need to write a trigger to this using Oracle sequences

some thing like

select <your_sequence>.nextval into :new.testID from dual; Sree Received on Sat Apr 11 1998 - 18:41:31 CDT