1. Home
  2. Point-Of-Sale Software
  3. Update Recordset to Database

Update Recordset to Database

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

Reply to
falunkai
Loading thread data ...

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

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

"falunkai" wrote:

Reply to
Randall

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.