Question
· Oct 24, 2023

EnsLib.SQL.OutboundAdapter - Getting the row count for Select Query

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).")

Product version: IRIS 2022.1
Discussion (2)2
Log in or sign up to continue