ODBCSetSort

Sorts the records selected in a database.

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

Syntax

ODBCSetSort(numHandler,strSort)
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" )