>I am creating a new dbf file based upon filters used each time a user wishes to print a report. However, I need to evaluate if the database is empty so that I can return an error message and gracefully close down that part of the program and return the user back to the filter option dialogue screen.
>
>My main question is how can I evaluate whether a dbf table has any data or none at all and include this command in an IF..ENDIF statement.
>
>Can anyone help me please....
>
>Thanks
>
>Brendan

locate
if found()
* you got records
else
* no you don't
endif