Using the OpenResultset Method

No matter which type of query you execute, or which type of result set you create, you must use the OpenResultset method to build an rdoResultset to fetch and navigate through the data rows. The connection and specific cursor type used to create the rdoResultset depends on the properties of the object referenced with the OpenResultset method. For example, if you execute the OpenResultset against the rdoQuery object, RDO uses the connection specified in its ActiveConnection property and the cursor type specified in its CursorDriver property.

The OpenResultset method accepts the following arguments:

Choosing a Cursor Type

Using arguments of the OpenResultset method or properties of the rdoQuery object, you can specify the type of cursor (if any) and other attributes of the rdoResultset object. However, in many cases, cursors are not the best way to retrieve data as they negatively affect performance and resource utilization.

For More Information   See "OpenResultset Method," "Type Property," and "SQL Property" in the Language Reference".