Autonumber

From: bubba <brittonb_at_webt.com>
Date: Thu, 9 Apr 1998 15:50:50 -0400
Message-ID: <352d261c.0@news.webt.com>

In MS Access there is an autonumber type which guarentees a unique primary key that is automatically generated.

I have created a test table with two fields on an oracle database.

testID ---primary key - unique
TestData -- varchar2 (50) nulls allowed

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?

What am i doing wrong?

brittonb_at_webt.com Received on Thu Apr 09 1998 - 14:50:50 CDT