Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I'm looking too hard.
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00002996
Message ID:
00003000
Views:
42
>>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
** ** ** ** ** ** ** ** ** ** **
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform