Daven81 Posted August 10, 2003 Posted August 10, 2003 guys i encounter an error like this when i try to add a new record and i don't understand it. i am using vb.net with sqlserver "An explicit value for the identity column in table 'supplier' can only be specified when a column list is used and IDENTITY_INSERT is ON." please help Quote
Moderators Robby Posted August 11, 2003 Moderators Posted August 11, 2003 DO you have an ID column in Supplier? Quote Visit...Bassic Software
Daven81 Posted August 11, 2003 Author Posted August 11, 2003 yes i do. on another form i use the same coding and can add the data Quote
csharpener Posted August 12, 2003 Posted August 12, 2003 the error is a bit vague but it appears to me that the record you are trying to insert has an int identity or autonumber and the code you are using is trying to assert a primary key value. check the INSERT statement to see if your dataset or code is trying to specify what the primary key value will be - SQL server is probably handling this management itself and saying to your vb.net code "Bugger Off thats my job PaL"... Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.