CDaoQueryDef::SetSQL

Call this member function to set the SQL statement that the querydef executes.

void SetSQL( 
   LPCTSTR lpszSQL  
);

Parameters

  • lpszSQL
    A string containing a complete SQL statement, suitable for execution. The syntax of this string depends on the DBMS that your query targets. For a discussion of syntax used in the Microsoft Jet database engine, see the topic "Building SQL Statements in Code" in DAO Help.

Remarks

A typical use of SetSQL is setting up a querydef object for use in a SQL pass-through query. (For the syntax of SQL pass-through queries on your target DBMS, see the documentation for your DBMS.)

Requirements

Header: afxdao.h

See Also

Concepts

CDaoQueryDef Class

CDaoQueryDef Members

Hierarchy Chart

CDaoQueryDef::GetSQL

CDaoQueryDef::SetName

CDaoQueryDef::SetConnect

CDaoQueryDef::SetODBCTimeout

CDaoQueryDef::SetReturnsRecords