About IDO methods

IDOs (Intelligent Data Objects) can use two kinds of methods: standard methods and custom methods.

Standard methods

All IDOs implement the methods LoadCollection, UpdateCollection, GetPropertyInfo, and Invoke.

  • LoadCollection retrieves a collection of rows from the database.
  • UpdateCollection takes a set of rows marked for insert, update, or delete, and executes the appropriate SQL code on the database.
  • GetPropertyInfo returns detailed information about the properties supported by the IDO.
  • Invoke executes a custom method.

Custom Methods

Custom methods are defined by the developer. You can define custom methods that are implemented in Transact-SQL. Transact-SQL is the preferred programming language because it is easier to use for most of these tasks and because the IDO forms provide useful facilities for defining methods based on these procedures.

There are two kinds of methods based on Transact-SQL stored procedures:

  • Methods based on stored procedures without a result set
  • Methods based on stored procedures with a result set

A stored procedure that does not return a result set can have both input parameters and output parameters, but it does not select data to be returned to the caller.

You can use a method that returns a result set to the caller (a list of values) to populate collections. A typical use is to populate drop-down list boxes in forms. You can also bind forms to these returned sets.