RS.Update will not update the field

[nirajj]

Hi,

I have a rdo connection to the SQL server 2K DB.

The following code is used to update certain data in the table.

Set Rs = Connection.OpenResultset("Select * from Table, rdOpenDynamic, rdConcurRowVer)

Rs.Requery
Rs.Edit
Rs!fld1 = 'abc12345'
Rs!fld2 = 'abcdef'
Rs.Update

However, the data remains unchanged. There is no update in the table.

I am not too proficient with VB and do not know what exactly could be the problem. Any help would be highly appreciated.

Thanks

 

[RobSchultz]

Your connection can't use the default adOpenForwardOnly and can't be opened in read-only mode (try Cursor type = adOpenKeyset, Lock Type = adLockOptimistic, Cursor location = adUseClient). I'm thinking you also need to .UpdateBatch at the end of your updates otherwise it doesn't get pushed to the database.

HtH,

Rob

-Focus on the solution to the problem, not the obstacles in the way.-

 

[nirajj]

Hi Rob ...

thank you very much for the reply...

however i took the RS.Requery out (didnt know wt it was doing there exactly) and the program seems to be running good now ...

thank you