ASP Database Fundamentals (Part 4) - Updating Existing Records
(Page 2 of 9 )
If your database application did not have the ability to update or modify existing database entries, then it would be severely limiting in its potential. For example, imagine having a customer database in which you did not have the ability to change the contact information for a customer. You would not be able to update the customer’s mailing address, phone number, or email address. How about an inventory management system that had an inability to update the price or quantity of an item in stock?
For today’s mainstream database applications, database maintenance is a necessity. To that end, there are two main methods of updating information utilizing ADO. These methods very closely reflect the methods we discussed when learning to insert items into the database. They involve using the recordset object, as well as the connection object directly.
Next: Updating Records with the Recordset Object >>
More ASP Articles
More By Rich Smith