DAO Collections: Obtaining Information About DAO Objects

|  Overview |  How Do I |  FAQ |  Sample |  |  ODBC Driver List

Objects of most of the MFC DAO classes contain “collections” of subordinate objects. For example, a object contains collections of tabledefs, querydefs, and relations. For an explanation of how these collections fit into the MFC implementation, see the article DAO Collections.

The present article explains how to obtain information about the objects in a collection. The example given uses the database object’s QueryDefs collection, but the same mechanism applies to other collections throughout the MFC implementation of DAO.

Topics covered include:

• Functions for accessing DAO collections

• Information returned by the GetXInfo functions

• Example: Obtaining Information About Querydefs

• Constants for specifying the levels of information you want

Functions for Accessing DAO Collections

Access the objects in a DAO collection through the GetXCount and GetXInfo member functions of the appropriate class, where X stands for Database, Field, Index, Parameter, Query, Table, Relation, or Workspace. The following table lists the available collection-access functions for each MFC class.

Class Member Functions for Accessing Collections

Information Returned by the GetXInfo Functions

In general, use GetXCount functions to determine the upper bound for looping through a collection. On each iteration of the loop, call GetXInfo functions to retrieve the information. The GetXInfo functions return a reference to an object of class CDaoXInfo, which you can examine. Each different CDaoXInfo class (technically a C++ structure) supplies different information. You pass an object of type CDaoXInfo in the second (xinfo) parameter.

****Note   ****DAO collections are zero-based. When you iterate a collection, begin with element 0.

The following table lists the CDaoXInfo classes. See the class for details about its members.