Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by clause in vfp8
Message
From
22/04/2003 02:32:16
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00774269
Message ID:
00780044
Views:
40
>>>MIN() would be a function in the true sense of the word if it received a parameter and returned a value. In this case, it results in the smallest value of those it's received. Therefore, each field has to be examined and compared, internally in this instance. Regardless of how one equates them, it is, nonetheless, a function.
>>
>>It is only intepretated ones....
>>
>Walter,

>Nope! Each record has to be examined, unless an index exists on the individual field.

Please read carefully, I said interpreted ones, not called ones. Further the aggregated functions do not make use of indexes in VFP.

>The code is interpreted once, the function is called multiple times.

Correct, that still is a big difference when comparing to your example.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform