>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()
endif
To find the actual number of records, you can use the COUNT command.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)