RecordSet Methods and Properties

Abstract

There are two ways to work with a database using ADO. One technique is to incorporate all of the selecting, sorting, editing, and deleting into SQL statements. (In Chapter 10 we will utilize action queries using the SQL keywords upate, insert, and delete to makes changes in our data.) The second technique, covered in this chapter, is to perform these tasks using methods available to the recordset. SQL statements can handle far more complex objectives than methods. However, for some simple tasks, the various recordset methods work very well. In addition, methods can be applied after a SQL statement has performed an initial action. Furthermore, as a site designer you will come across legacy code which relies on these methods.