This topic has not yet been rated - Rate this topic

CDaoDatabase::GetQueryDefInfo

Visual Studio 2012

Call this member function to obtain various kinds of information about a query defined in the database.

void GetQueryDefInfo( 
   int nIndex, 
   CDaoQueryDefInfo& querydefinfo, 
   DWORD dwInfoOptions = AFX_DAO_PRIMARY_INFO  
); 
void GetQueryDefInfo( 
   LPCTSTR lpszName, 
   CDaoQueryDefInfo& querydefinfo, 
   DWORD dwInfoOptions = AFX_DAO_PRIMARY_INFO  
);

Parameters

nIndex

The index of the predefined query in the database's QueryDefs collection, for lookup by index.

querydefinfo

A reference to a CDaoQueryDefInfo object that returns the information requested.

dwInfoOptions

Options that specify which information about the recordset to retrieve. The available options are listed here along with what they cause the function to return about the recordset:

AFX_DAO_PRIMARY_INFO (Default) Name, Type
AFX_DAO_SECONDARY_INFO Primary information plus: Date Created, Date of Last Update, Returns Records, Updatable
AFX_DAO_ALL_INFO Primary and secondary information plus: SQL, Connect, ODBCTimeout

lpszName

A string containing the name of a query defined in the database, for lookup by name.

Remarks

Two versions of the function are supplied so you can select a query either by index in the database's QueryDefs collection or by the name of the query.

For a description of the information returned in querydefinfo, see the CDaoQueryDefInfo structure. This structure has members that correspond to the items of information listed above in the description of dwInfoOptions. If you request one level of information, you get any prior levels of information as well.

Requirements

Header: afxdao.h

Reference

CDaoDatabase Class

Hierarchy Chart

CDaoDatabase::GetQueryDefCount

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)