• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Manipulating Data with ADO > Updating Data in a Recordset

Updating Data in a Recordset

Updating (or editing) existing data in a Recordset pulls together parts of most of the previous sections. After creating and populating the Recordset object, you must find the record or records you want to modify. Then, you commit the change by executing an ADO Update method, which you reviewed earlier in the “Adding Data Using a Recordset” section on p. 260.

Caution

Before you can actually run any of the procedures in this section, you must change the Field Size property of the State field in the Clients table to 10 or greater. If you don’t, the procedures will return an error because the State field won’t be large enough to accommodate the string “California.”



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint