CDaoQueryDef::GetType

short GetType( );
throw( CDaoException, CMemoryException );

Return Value

The type of the query defined by the querydef. For values, see Remarks.

Remarks

Call this member function to determine the query type of the querydef. The query type is set by what you specify in the querydef’s SQL string when you create the querydef or call an existing querydef’s SetSQL member function. The query type returned by this function can be one of the following values:

• dbQSelect   Select
  
  
• dbQAction   Action
  
  
• dbQCrosstab   Crosstab
  
  
• dbQDelete   Delete
  
  
• dbQUpdate   Update
  
  
• dbQAppend   Append
  
  
• dbQMakeTable   Make-table
  
  
• dbQDDL   Data-definition
  
  
• dbQSQLPassThrough   Pass-through
  
  
• dbQSetOperation   Union
  
  
• dbQSPTBulk   Used with dbQSQLPassThrough to specify a query that does not return records.

Note   To create an SQL pass-through query, don’t set the dbSQLPassThrough constant. This is set automatically by the Microsoft Jet database engine when you create a querydef object and set the connect string.

For information about SQL strings, see GetSQL. For information about query types, see Execute.

CDaoQueryDef Overview |  Class Members |  Hierarchy Chart