Appendix: Built-in Scripting Language Examples ODBCExecuteSQL Directly executes an SQL statement. Syntax ODBCExecuteSQL( numHandler , strSqlCommand ) numHandler The handler returned by the ODBCOpen function. strSqlCommand A valid SQL statement. Returned value Note: This function does not return any records, regardless of the statement that is executed. Examples ODBCInsert Inserts a new record in the database. Syntax ODBCInsert( numHandler ) numHandler The handler returned by the ODBCOpen function.
Returned value Page 582 InduSoft Web Studio Tag Name Expression Tag ODBCDelete( 5 ) Group Execution Windows PC Windows CE Thin Client ODBC Synchronous Supported Not supported Executed on Server 0 Success 1 Invalid handler 2 Database not open 3 Invalid parameter 4 Error executing SQL command Tag Name Expression Tag ODBCExecuteSQL( 3, " ) Tag ODBCExecuteSQL( 4, " ) Function Group Execution Windows Embedded Thin Client ODBCInsert ODBC Synchronous Supported Not supported Executed on Server 0 Success 1 Invalid handler 2 Database not open 3 Insert error