>Anyone know of a function to simply tell if there is data in a table, MINUS the deleted records. I was using reccount() until I noticed I didn't want to see deleted records either. If reccount()=0 there is no records, but I want to ignore DELETED as well. In a transfer.dbf, I want to see if there are any non-deleted records in it, so I can start a transfer process. Thanks for responses.
It seems simple enough:
Count to nondels for !deleted()
An index tag with deleted() as part of its key would speed this up significantly.
Am I missing something?
Thank you,
Pete