>Is there a way to get a record count with a FILTER in effect? I mean a record count of all the items within the filter's limits? I know that RECCOUNT() will still count ALL records, not being affected by SET FILTER.
>
>The problem I am having is to be able to control the problem of EOF and BOF when there are no records within the FILTER setting, and then you hit the navigational buttons and erros jump up for BOF and EOF.
>
>Cecil
You can run a select statement with the same condition as a filter to get the number of records. Alternatively you can COUNT FOR the same condition as filter.
Finally, you can switch to a better technique than a filter.
If it's not broken, fix it until it is.
My Blog