Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>Are you doing this on a cursor that contains only the messages for the specified user or on the whole dbf?
>>>
>>>There are others condition that I remove which will only takes the current forum, the current users, etc.
>>>
>>>Yes, it's on the main table.
>>
>>In this case, I think it sould be a little faster:
>>
>>ldDate3 = GOMONTH(ldDate2,1)-1
>>COUNT FOR BETWEEN(ADDDATE, ldDate2, ldDate3) TO lnMessage
>>
>>Because ldDate3 formula will be evaluated only once and not for each record.
>
>Is it really the case? I mean, the evaluation per record. I thought that it's only at first just to get the range.
I'm not very sure what FoxPro will optimize in such an expression, so I can't tell you for sure. But I think it will evaluate it for each record.
Vlad
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement