Manipulating Your Recordset

Abstract

in chapter 6, we discussed how, when, and why to construct a Recordset. Once you decide to create a Recordset to handle the rowset generated by your query, you will want to manipulate it. You’ll think about binding it to data-aware controls (I suggest you don’t), and think about sorting, filtering, and finding rows in the rowset (I suggest you do). When you paid up to seven some-odd megabytes of RAM for ADO, you mostly bought sophisticated Recordset management routines. Knowing how to use these routines efficiently and effectively will go a long way toward making your application a success.