Update data using ADO
Posted on 2004-11-30
I opened an ADO recordset using the following statement.
objRS.Open "dbo.sp_837p_claim (" & TranDetailId & ", " & ClaimId & ")", _
m_objConn, adOpenKeyset, adLockOptimistic, adCmdStoredProc
I tried to update data from the screen in this recordset by doing the following
objRS!ClmNum = txtClmNum
objRS!ProviderId = txtProviderId
When I come back into the record the data has not been changed.
What should be done to update the data? I do know about using an UPDATE SQL statement and maybe that is route I will take but I am trying to figure out why this does not work with the update method of the recordset.