ODBCExecuteSQL
Directly executes an SQL statement.
| Function
| Group
| Execution
| Windows
| Embedded
| Thin Client
| Mobile Access
|
| ODBCExecuteSQL | ODBC
| Synchronous
| Supported
| Not supported
| Executed on Server
| Not supported
|
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, ” ) |
ODBCExecuteSQL