omron — ODBCSetSort

Appendix: Built-in Scripting Language Examples ODBCSetFilter Constrains the records selected in a database. Syntax ODBCSetFilter( numHandler , strFilter ) numHandler strFilter The handler returned by the ODBCOpen function. The a SQL WHERE clause. Returned value Notes You may find this function useful for selecting a subset of records, such as "all salespersons based in California" ( "state = 'CA'" ). Remember to call ODBCQuery after calling this function. Examples ODBCSetSort Sorts the records selected in a database. Syntax ODBCSetSort( numHandler , strSort ) numHandler The handler returned by the ODBCOpen function. strSort The SQL ORDER BY clause.

Returned value Page 590 InduSoft Web Studio 2 Database not open 3 Invalid parameter 4 Invalid column name Tag Name Expression Tag ODBCSetFieldNULL( 2, "Price", 1 ) Tag ODBCSetFieldNULL( 4, "CompanyName", 0 ) Function Group Execution Windows Embedded Thin Client ODBCSetFilter ODBC Synchronous Supported Not supported Executed on Server 0 Success 1 Invalid handler 2 Invalid parameter Tag Name Expression Tag ODBCSetFilter( 3, "Name='Morgan'" ) Function Group Execution Windows Embedded Thin Client ODBCSetSort ODBC Synchronous Supported Not supported Executed on Server 0 Success