Manipulating Your Recordset
In chapter 6, I 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 about sorting, filtering, and finding rows in the rowset (I suggest you do). When you paid 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.
KeywordsOutput Parameter Variant Array Event Handler Field Object Action Query
Unable to display preview. Download preview PDF.