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
Reference
CDaoQueryDef::SetReturnsRecords