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 |
rdoResultset | rdoQuery(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. |