Creating Remote Data Objects

You can use the RemoteData control to create RDO objects, just as you can use the Data control to create DAO objects. You can also create result sets using RDO methods and pass them to the RemoteData control for management and editing by associated bound controls.

Remote Data Objects are also created by using methods on the parent object, or by declaring the objects with the Dim statement. If you use the Dim as New statement to instantiate a new object, the object is not appended to the associated collection. The following table shows how to create each of the primary Remote Data Objects:

Remote Data Object How created
rdoEngine Created automatically.
rdoEnvironment First instance created automatically. rdoEngine.rdoCreateEnvironment
rdoConnection rdoEnvironment(x).OpenConnection
(can also be created by the RemoteData control)
Dim MyCn as New rdoConnection
rdoQuery rdoConnections(x).CreateQuery
Dim MyQry as New rdoQuery
rdoResultset rdoQuery(x).OpenResultset
rdoConnection(x).OpenResultset
(can also be created by the RemoteData control)
rdoParameter Created automatically for parameter queries.
rdoTable Created automatically when referenced.
rdoError Created automatically when ODBC errors or messages are returned.