If it's actually an autonumber field (at least with SQL Server), just insert
the rest of the fields (not including the autonumbered field), e.g.
(presuming your table includes First_Name,Last_Name, and an
autonumber...say, a Customer_ID field):
"INSERT INTO tblMyData(First_Name,Last_Name) VALUES('Sam','Adams')"
The table will automatically generate the autonumber for the ID field, hence
the name ;-). Additionally, if you *try* to insert a value into the
autonumber field, SQL Server will generate an error. I'm not sure whether
there may be different behaviors in different DBs...anyone?
HTH
-----Original Message-----
From: �ystein Walle [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 3:37 AM
To: Orion-Interest
Subject: When using autonumber for the primarykey...
I'm just wondering what to do when inserting into a table where the
primarykey has incremental int type?
Is this possible?
Please help.
Walle
