PDA

Click to See Complete Forum and Search --> : SQL Server -need help from wise person


Jimbob
Jul 6th, 2000, 11:07 AM
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
Jul 6th, 2000, 11:21 AM
Are you attemting to update a view or a table?

Jimbob
Jul 7th, 2000, 03:08 AM
i'm trying to update the table

Jimbob
Jul 7th, 2000, 03:46 AM
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!!!