Directly executes an SQL statement.
| Group |
Execution |
Windows PC |
Windows CE |
Thin Client |
|
ODBC
|
Synchronous |
Supported |
Not supported |
Executed on Server |
Syntax
ODBCExecuteSQL( numHandler, strSqlCommand )
- numHandler
- The handler returned by the
ODBCOpen function.
- strSqlCommand
- A valid SQL statement.
Returned value
| 0 |
Success |
| 1 |
Invalid
handler |
| 2 |
Database
not open |
| 3 |
Invalid
parameter |
| 4 |
Error
executing SQL command |
Note: This
function does not return any records, regardless of the statement
that is executed.
Examples
|
Tag Name |
Expression |
|
Tag |
ODBCExecuteSQL( 3, " )
|
|
Tag |
ODBCExecuteSQL( 4, " )
|