|
DaoDatabase:Execute() Method |
  
|
|
DaoDatabase:Execute() Method |
|
Purpose
Execute an SQL statement
Parameters
| cQuery | A string that is an SQL statement. |
| lOptions | (Optional) A constant or combination of constants that determines the data integrity characteristics of the query |
Returns
NIL
'
Remarks
You can use the following constants for IOptions
| 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). |
Class
Example