CdbQueryDef::Execute Method

Runs an action query or executes an SQL statement on a specified Connection or Database object.

Syntax

VOIDExecute(LONG lOption=-1);

Parameters

Type Example Description
LONG lOption Optional. A constant or combination of constants that determines the data integrity characteristics of the query, as specified in Settings.

Settings

You can use the following constants for options.

Constant Description
dbDenyWrite Denies write permission to other users (Microsoft Jet workspaces only).
dbInconsistent (Default) Executes inconsistent updates (Microsoft Jet workspaces only).
dbConsistent Executes consistent updates (Microsoft Jet workspaces only).
dbSQLPassThrough Executes an SQL pass-through query. Setting this option passes the SQL statement to an ODBC database for processing (Microsoft Jet workspaces only).
dbFailOnError Rolls back updates if an error occurs (Microsoft Jet workspaces only).
dbSeeChanges Generates a run-time error if another user is changing data you are editing (Microsoft Jet workspaces only).
dbRunAsync Executes the query asynchronously (ODBCDirect Connection and QueryDef objects only).
dbExecDirect Executes the statement without first calling SQLPrepare ODBC API function (ODBCDirect Connection and QueryDef objects only).

Note that the constants dbConsistent and dbInconsistent are mutually exclusive. You can use one or the other, but not both.

Usage

#include <afxole.h>
#include <dbdao.h>

CdbQueryDef       qd;
CdbConnection   conn;
LPCTSTR    lpctsrSQL = 
            _T("SELECT SALARY FROM EMPLOYEES ")
            _T("WHERE LASTNAME = 'SMITH'");
...
qd = conn.CreateQueryDef(_T("SALARYDEF"), lpctsrSQL);
qd.Execute(dbFailOnError);