>>I have a table that has a filter. If no records satisfy the filter, how can I tell? The RecCount() shows the number in the table, not just those in the filtered result. I need to know if the filtered result is empty.
>
>
>set filter to ...
>go top
>if eof()
> * Empty
>endif
>
>
>To find the actual number of records, you can use the COUNT command.
GO TOP is not optimizable. The LOCATE is.
--sb--