Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is wrong with my use of reccount()?
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01021449
Message ID:
01021488
Views:
17
>
>If I may ask you a follow up question, please.
>
>If I wanted to simply know how many records in a table matching some WHERE clause, and I want it as fast as possible (and then close the table), and I don't know how many records are in the resulting query (could be 1 or could be 1000 but probably not more than 1000), would your answer, "it depends" still apply?

I'm not sure I uderstand your question. Anyway, why don't you use
SELECT COUNT(*) WHERE < condition > INTO ARRAY laCount
* or 
COUNT FOR < condition >
?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform