Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select and sum
Message
De
21/06/2005 05:11:24
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Divers
Thread ID:
01024603
Message ID:
01025070
Vues:
23
hi,
i need help to
sum m1_m,m2_m....to m12_m insert it at new filed
sum m1_a,m2_a....to m12_a insert it at new filed

at the end of file append new record
sum
first  record  m1_m  m1_a    m2_m  m2_a
second record  m1_m  m1_a    m2_m  m2_a 
.      .       .     .        .     .
.      .       .     .        .     .
.      .       .     .        .     .
.      .       .     .        .     . 
-------------------------------------------
total      5421:45: .......................
thank you
m.qasem

>>hi,
>>the functin is work ,
>>i mean the result not the same if i calculate it manualy,
>>just if you have atime to test my seconds 540600.
>>
>
* FUNCTION Sec2Str
>LPARAMETERS tnSeconds, llDays
>LOCAL lcHH, lnTm, lcMM, lcSS, lcTime
>lnTm = tnSeconds
>IF llDays
>	lcDD = TRANSFORM(INT(lnTm / 86400), "99") + " "
>	lnTm = tnSeconds % 86400
>	lcHH = TRANSFORM(INT(lnTm / 3600), "@L 99")
>ELSE	
>	lcDD = ""
>	lcHH = TRANSFORM(INT(lnTm / 3600), "@L 999")
>ENDIF	
>lnTm = lnTm % 3600
>lcMM = TRANSFORM(INT(lnTm / 60), "@L 99")
>lcSS = TRANSFORM(INT(lnTm % 60), "@L 99")
>lcTime = lcDD + lcHH + ":" + lcMM + ":" + lcSS
>RETURN lcTime
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform