return number of rows from a query

SELECT COUNT(*) FROM MYTABLE WHERE X = ‘Y’

I think that depends on the type of query that you are doing.

Looking at one of our queries, we use SQLExecDirect to execute the query, then we repeatedly call SQLFetch to fetch each row until SQLFetch returns SQL_NO_DATA_FOUND.  If I wanted to count the rows returned, I’d probably just keep a counter that I incremented each time we successfully called SQLFetch.