Hi,

I've used PHP with MySQL and I was able to count the rows of a table by
using the following code:

SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName;
SELECT FOUND_ROWS();

However, I would like to do the same thing using Visual Basic 6...

When I set the RS.Source to the first SELECT statement and open it, it
run OK but I need to close the RS and open it again using the second
SELECT statement.

After any of this operations I get a Recordset->RecordsCount = 1

How can I work this out?

Thanks

Hi,

Nuno Oliveira wrote:
> When I set the RS.Source to the first SELECT statement and open it, it
> run OK but I need to close the RS and open it again using the second
> SELECT statement.
>
> After any of this operations I get a Recordset->RecordsCount = 1

That is actually a correct figure, SELECT FOUND_ROWS() returns exactly
one record *CONTAINING* the number of found rows. So you have to access
the resultset to get the actual number of rows. SELECT
SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by
the way.

regards
Nils