SQL Server -need help from wise person

[Jimbob]

trying to set the value of an integer field in a sql server database, like this

DS1.RS.AddNew
DS1.RS!PAXCount = <an integer value>
<set a few more fields>
DS1.RS.Update

when executing the line that sets the value, I get this error: -

Run-time error '-2147217887 (80040e21)':
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

this error doesnt get caught by my error trapping, and being new to ADO, I dont have a clue what an OLE DB Status Value is.

I'm off to look at the technet now, but i thought one of you folks might be able to give me an answer in plain english.

cheers!

[JHausmann]

Are you attemting to update a view or a table?

[Jimbob]

i'm trying to update the table

[Jimbob]

it's ok, figured it out now

the column i was trying to update was an identity column (d'oh!)

forgive me, i'm just a bit stupid at times!!!