#12 RecordCount not working

[Sharken]

RecordCount
I'm using a TSqlQueryPlus component with a sql code
like "Select * From Table". After i open it, I use the
following code :

Grid.RowCount:=SQLQueryPlus2.RecordCount+1;

No matter what i do, RecordCount always seems to
return 5 even though there are more records than that.

The problem seems to relate to that of another user
who also mentioned something about RecordCount and
the number 5.

Its also worth mentioning that if i test for
SQLQueryPlus2.Eof, its possible to get all records of the
recordset.

Thanks in Advance

[Nobody/Anonymous]

Logged In: NO

Perform a Last .... to go to the last record .....

SQLQueryPlus2.Last;
SQLQueryPlus2.First;
Grid.RowCount:=SQLQueryPlus2.RecordCount+1;

* This can be slow...