Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Month repartition from two dates
Message
De
13/07/1997 13:40:30
 
 
À
13/07/1997 13:14:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00039620
Message ID:
00039760
Vues:
36
>>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.

Vlad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform