ODBCSetSort

Sorts the records selected in a database.

Function Group Execution Windows Embedded Thin Client Mobile Access
ODBCSetSort ODBC Synchronous Supported Not supported Executed on Server Not supported

Syntax

Web Studio Help r function odbc odbcsetsort.xml d186774e76 ODBCSetSort
numHandler
The handler returned by the ODBCOpen function.
strSort
The SQL ORDER BY clause.

Returned value

0 Success
1 Invalid handler
2 Invalid parameter type

Notes

You can use this feature to sort the records in one or more columns. Remember to call ODBCQuery after calling this function.

Examples

Tag Name Expression
Tag ODBCSetSort( 5, “Name DESC” )

ODBCSetSort