Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not counting deleted records
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01223920
Message ID:
01223932
Views:
23
>>hi all,
>>I want to initialise some setting in a program depending on record in a dbf file. i was thinking of
>>
>>use table1
>>if reccount() > 0
>>...
>>
>>the only problem is that this table could have a deleted record, very hard to use excl and pack and i want reccount() to only work with non-deleted records, is there a way to do this?
>>~M
>
>
USE table1
>GO BOTTOM
>IF NOT BOF() AND NOT EOF()
>...
>
That actually answers the question in the message itself and not in the title! :)
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform