My application is written C++. I can retrieve column information but
when I do a SELECT that returns a number, I don't know how to retrieve
it. An example is:

SELECT COUNT(*) FROM mytable;

Can someone point me in the right direction?

Alan