Creating rdoResultset Objects

While RDO has a number of options to make the process of retrieving result sets and returned parameters easier, all of them ultimately result in the creation of an rdoResultset object. For example, all of the following techniques can be used to create and manage rdoResultset objects:

• Use the OpenResultset method against an rdoConnection object. This is used to submit a query that you do not expect to execute more than once in your application. The returned rows are placed in an rdoResultset object.
  
  
• Use the OpenResultset method against an rdoQuery object. This technique is used to submit a query that you expect to execute more than once in your application or that requires one or more parameters. The returned rows are placed in an rdoResultset object and any parameters returned from the query are referenced via the rdoQuery object's rdoParameters collection.
  
  
• Create a stand-alone rdoQuery object, set its properties, and associate it with a specific connection using the ActiveConnection property. An rdoResultset object can then be created against the enabled rdoQuery using the OpenResultset method. The ActiveConnection property can be changed to refer to a different connection and the query re-executed without having to create another rdoResultset object.

For More Information   See "Creating RDO Parameter Queries" later in this chapter.