AutoIncrement, Primary Key -- MS SQL ... problems.

[Jeremy Cowgar]

Greetings!

I have a simple table:

CREATE TABLE UserInfo (
        userID int IDENTITY(1,1) NOT NULL,
        userCode varchar(15)
);

I have made a simple entity bean to manipulate this table (in real life it
contains many more fields). How do I cause Orion to read the userID via a
function getuserID() but *NOT* write to it when creating a new record, or
entity bean:

UserInfo ui = userInfoHome.create('JEREMY');

??? I will always get a CreateException:

javax.ejb.CreateException: Error creating EntityBean: [ADAM]Cannot insert
explicit value for identity column in table 'UserInfo' when IDENTITY_INSERT
is set to OFF.

Can anyone help?

Jeremy Cowgar - [EMAIL PROTECTED]
Christian Brotherhood Newsletter