Visual Basic Concepts

  • Article

Features of Remote Data Objects

With RDO and the RemoteData control, your applications can access ODBC data sources without using a local query processor. This can mean significantly higher performance and more flexibility when accessing remote database engines.

By using RDO, you can:

  • Create simple cursorless result sets, or more complex cursors.

  • Run queries and process any number of result sets.

  • Execute stored procedures that return result sets with or without output parameters and return values.

  • Execute action queries that perform data manipulation or data definition operations.

  • Limit the number of rows returned or processed.

  • Monitor all of the messages and errors generated by the remote data source without compromising the executing query.

  • Enable synchronous, asynchronous, or event-driven asynchronous processing so your application isn't blocked while lengthy queries are executed or the current row pointer is repositioned.

About the User Connection Designer

The User Connection Designer uses Microsoft Visual Basic’s new class designer architecture to provide design-time support for programmatic data access. It allows you to create connection and query objects (based on Remote Data Objects) at design time. These connections and queries are persisted as project-level objects. You can preset properties, define new properties and methods, and write code behind the objects to trap events.

This provides a simplified method for responding to events raised from connections and queries as well as for calling stored procedures and client-defined queries at run time.