A RecordSet is an in-memory copy of a collection of records retrieved from the server using some type of selection commands (with or without filtering and sorting criteria). A RecordSet can be used by the application or the user to cruise through records of data. Because a RecordSet must be loaded in its entirety into the client’s PC memory before it can be used, loading large RecordSets may cause system performance problems. To limit the number of records to load, it is good practice to implement some type of filtering mechanism to reduce the number of records to return.
The following tutorial demonstrates how to retrieve a filtered RecordSet and how to cruise data. We create buttons that allow the user to move the current record pointer to the first, last, previous, or next record in a RecordSet. We also learn how to extract Records from a RecordSet and how to extract Fields from a Record.
These functions are performed using the RDTA.PickDP.Connector class library.
This section contains these topics: