>>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.
Since you are using the data for reports only (not updating),
you may want to consider using SQL Select instead of filters.
If is much faster.
SELECT ;
yourdbf.* ,;
" " AS junk ; && Make sure written cursort so _tally is correct.
FROM yourdbf ;
WHERE .... ;
INTO CURSOR temp
IF _tally=0 && Any records returned in cursor
* print your report
ENDIF
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only