Home Page link  

Update Recordset to Database

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Update Recordset to Database falunkai 12-08-2006
Posted by falunkai on December 8, 2006, 1:58 pm
Please log in for more thread options
 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

Posted by Randall on December 11, 2006, 12:27 am
Please log in for more thread options
 You need to execute a UPDATE in the Openrecorset...

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




"falunkai" wrote:

> 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

Similar ThreadsPosted
display ADO object Recordset in html November 4, 2005, 2:42 pm
Returning records from Recordset object November 26, 2006, 12:26 am
Worksheet 51 to copy from HQ database to each store database July 8, 2008, 12:07 pm
Can connect to HQ database but not Store database November 16, 2005, 12:17 am
synchronize a store database to another HQ database June 8, 2006, 9:52 am
Update September 21, 2005, 5:54 pm
update from 1.2 to 1.3 August 11, 2006, 12:51 am
Need update January 13, 2007, 7:47 pm
what is the last RMS update? and where can I get it? April 17, 2007, 1:46 pm
Update HQ from SO May 11, 2007, 3:43 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap