Update Recordset to Database

Dec 08, 2006 1 Replies

Please someone to helpme, I use Openrecordset to query Database Dim Rs as Adodb.Recordset set RS = Object.Openrecordset("Select * from Customer where ID =1",False) RS.Field("CustomNumber1").Value = 10 RS.Update



My Customer value in Recordset is update = 10 But Customer Table isn't update , I don't Know how to update value from Recordset to Database , Please Tell me , Thanks you very much


You need to execute a UPDATE in the Openrecorset...

Openrecordset("update Customer set CustomerNuber=1 where ID =1",False)

"falunkai" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required