We would like to know how to get the Row Count of the SELECT query. We query external database via ODBC connection.
//tSQL- is a select query.
Set tStatus = ..Adapter.ExecuteQuery(.tResult,tSQL)
We are trying to get the row count of the retrieved records as below; but It doesn't return any value.
tResult.%ROWCOUNT
$$$TRACE("Result set returned with "_tResult.%ROWCOUNT_" row(s).")