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:
00003517
Views:
36
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform