return number of rows from a query

[Rick Pritchett]

Need to know how to get the number of rows returned by a query using the odbc drivers.

Topic

[Charlie Bursell]

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

[David Barr]

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.

[Author]

Replies