Connecting With RDO

Building Result Sets with RDO

To build a result set with RDO, you must declare objects, define the desired result sets through a query or table, and execute the appropriate method.

Resultset Object

A Resultset object represents the rows returned from a query. Resultset objects are created using the OpenResultset method of the rdoQuery , rdoTable , or rdoConnection objects.

Example

This example creates a Resultset object variable in Visual Basic. Using the SQL string, a result set is opened:

 Dim rs As rdoResultset Dim SQL As String SQL = "Select au_fname from Authors" Set rs = cn.OpenResultset(SQL, rdOpenKeyset, _ rdConcurReadOnly) 

---

Note

Complete details about the features and implementation issues associated with using RDO are outside the scope of this book. The above example is provided to give you an idea of what is required when you connect to a database using RDO.

---