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:
01223925
Views:
10
>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

RECCOUNT() function just read the header of the DBF to see how many records that DBF has, no matter if they are deleted or not. As Naomi suggest you must COUNT the records by yourself. Just don't forget to add a TAG based on DELETED() just to make sure that everything is optimizable.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform