Error in assigning string value to recorset field

[PANIk]

Basiaclly I have this code that opens a stored procedure

Set mUsersRecordset = New ADODB.Recordset

With mUsersRecordset
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockBatchOptimistic
.Open "Maintenance_Select_Users", Create_Connection, , , adCmdStoredProc
End With

Then I try to do this, when i either do an AddNew Or a Find to get a specific record

mUsersRecordset!User_Name = txtUserID.Text

And I get the following error

Run-time error '-2147217887 (80040e21)'
Multiple-step operation generated errors. Check each status value.

How do I check theses status. Thanx for your time

 

[CCLINT]

Has to do with using default values.
Read the following Kb article and see if that will help further.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q207684

or

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q279888

(note: Copy the whole URL instead of just clicking on it otherwise the site will not be found)

Or do a search on "Multiple-step operation generated errors" in the MS kb

 

[PANIk]

This applies to default values. My database design does not have default values. I can't use a server side cursor because a lot off adding and updating is done on the client side and then its batch updated. I don't think a server side cursor is wise.

It is giving me error with char fields not datetime.

I don't think that it still helps??

Thanx for the reply

 

[MathiKrishna]

You try this, I think this will help you

you change the lock type to adLockOptimistic
then compare the db value within a loop where you should check for not EOF that is
=================================
with rs
do while not .eof
if !user_id=txtUserId then
!name=txtname
------
------
bCheck=true 'bolean var to chk the availablity
.update
exit do
end if
.movenext
loop
end with
if not bcheck then
.addnew
!name=txtname
------
------
.update
end if

=====================
Regards,
Mathi Krishna
KEEP SMILING TODAY AND ALWAYS