Export (0) Print
Expand All

CDaoQueryDef::GetType 

Call this member function to determine the query type of the querydef.


short GetType( );

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

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.

NoteNote

To create a 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 connection string.

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

Community Additions

ADD
Show:
© 2015 Microsoft