Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best method to recalc total of a column in grid
Message
 
 
À
02/09/2008 11:27:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01344151
Message ID:
01344172
Vues:
26
Thx Edward

Setting the focus outside the grid has solved my problem.


>>I've got a grid of entries, the two important columns are a tick box (required), and a time in hrs (hrs).
>>
>>Where is the best method to recalculate the total hours (TxtNHours), in the click event method or the interactive change event?
>>
>>My calculation code looks like this:
>>
>>
>>DODEFAULT()
>>SELECT SUM(hrs) as total FROM linemarkingbody WITH (buffering=.t.) WHERE linemarkingbody.no=linemarkinghead.no AND required INTO CURSOR tmptotal
>>IF ISNULL(TMPTOTAL.TOTAL)
>> REPLACE totalhrs WITH 0 IN linemarkinghead
>>ELSE 
>> REPLACE totalhrs WITH tmptotal.total IN linemarkinghead
>>ENDIF 
>>thisform.txtNHours.Refresh 
>>
>
>It would be better to do it in InteractiveChange event, but remember to take focus out of the grid before calculating the sum.
Rob
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform