>>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.
>
>I haven't seen such a creature, but I imagine you
>could write one pretty easily....
>
>Scot.
Oh well, ended up writing this:
LOCATE FOR !DELETED()
IF FOUND()
*TELL BETSY
ENDIF
I also created an index so Rushmore would kick in.
Just thought there might be a hidden function out there.
** ** ** ** ** ** ** ** ** ** **
Gregory Cummines
Visual FoxPro 3.0/5.0
C/C++ Applications
** ** ** ** ** ** ** ** ** ** **