omron — ODBCBindCol

Appendix: Built-in Scripting Language ODBC functions These functions are used interact with an external database via Open Database Connectivity (ODBC). Note: These functions are provided to support legacy database interfaces. In most cases, we recommend that you use the newer Database/ERP connections manager and functions . ODBCBeginTrans Begins a transaction with the connected data source. Syntax ODBCBeginTrans( numHandler ) numHandler The handler returned by the ODBCOpen function. Returned value Examples ODBCBindCol Binds a column to a tag. Syntax ODBCBindCol( numHandler , strColName , strColType , strTagName ) numHandler The handler returned by the ODBCOpen function.

strColName The Database column name. strColType The SQL data type (one of the following): • SQL_BIT • SQL_TINYINT • SQL_LONGVARCHAR • SQL_CHAR • SQL_VARCHAR • SQL_DECIMAL Page 578 InduSoft Web Studio Function Group Execution Windows Embedded Thin Client ODBCBeginTran s ODBC Synchronous Supported Not supported Executed on Server 0 Success 1 Invalid handler 2 Database not open 3 Error beginning transaction Tag Name Expression Tag ODBCBeginTrans( 5 ) Function Group Execution Windows Embedded Thin Client ODBCBindCol ODBC Synchronous Supported Not supported Executed on Server