Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reccount()
Message
From
25/01/2010 21:49:53
Luis Navas
Independent Consultant
Auckland, New Zealand
 
 
To
25/01/2010 21:16:39
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01445855
Message ID:
01445941
Views:
26
>>>What about Set filter settings, and deleted records? I don't even consider using reccount(), since _tally will ALWAYS give me the correct info.
>>
>>
>>But you wrote after a Select statement, and in that case Reccount() will work fine, also Reccount() will ALWAYS give you correct info, the person that uses Reccount() could get confused if he does not understand what the function is returning, but the functions works fine all the time. :-)
>
>The reccount() does return the correct result always, because it always works the same way - it returns whatever the table (or cursor) header says is the current physical record count. Now it may differ from the number of visible records (deleted, filtered out, filtering cursor), so while it will still return the correct result, that result may not be the answer to the question the programmer had in mind, but to a somewhat different question. Which doesn't make it incorrect even in those cases, just wrong :).

LOL

Of course, wrong if the programmer doesn't know how Reccount() works
I never forget a face, but in your case I will make an exception :-)
Previous
Reply
Map
View

Click here to load this message in the networking platform