The
object is the real heart of the ADO. It's the primary mechanism we use to interact with a database. In previous chapters we've introduced the Recordset
, and seen what it has to offer. In this section, we'll consider some of the things we must take into account when creating Recordset
. Then we'll look at how we go about retrieving Binary Large Object (BLOB) data using a Recordsets
. Recordset
A
is in essence a cursor. A cursor is a subset of a database, organized and sorted in accordance with an SQL query. Cursors are powerful tools within a relational database engine. They allows developers to retrieve a subset of data, position that data in tables and columns, and then navigate the result set—both forward and backward—updating and changing the data as required. The following are some things to consider when creating and working with Recordset
.Recordsets