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:
01021493
Views:
20
>>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 >
?
>
>As soon as I sent you my message/question, I thought about the same, why not use COUNT(*). This way, no cursor is created and there will be only one element in the resulting array. I have not thought about COUNT FOR approach. It is probably RUSHMORE optimized too so it should work.

Yes, COUNT FOR will be RUSHMORE optimized if FOR condition is optimizable.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform