Thanks that was the awnser I was looking for.

Bernardo

>Hi Bernardo,
>
>>how do I know how many records does a query will retrive before issing the query?
>
>You need to execute the same query, but with COUNT(*) instead of the field list. However, this makes only sense if you talk about a SQL server as the backend or about a fully optimized query. In any other case, VFP would have to download all records, anyway.
>
>--
>Christof