Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Count exactly
Message
De
29/05/2006 08:27:07
 
 
À
29/05/2006 08:19:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01125645
Message ID:
01125647
Vues:
17
i think count to thisform.text2.value it must be as..
**count to thisform.text2.value 
 thisform.text2.value =thisform.text3.value +thisform.text4.value +thisform.text5.value +;
 thisform.text6.value+thisform.text7.value +thisform.text8.value  +thisform.text9.value+;
 thisform.text10.value+thisform.text11.value 
thanks
>hi all,
>i try via this code under to count records for every servey_num,
>
>ex...after count  servey_num=1  ,count=150
>                  servey_num=2  ,count=70
>                  servey_num=3  ,count=0
>total must be                          =220 && this is what i need
>
>i have record have servey_num=0
>
>i got total  =221  && this is rong
>
>
>
>thisform.grid1.VISIBLE=.f.
>ldDate=thisform.text1.value
>ldDate1=thisform.text12.value
>SELECT * FROM mstr  into cursor csrmyCursor  where  BETWEEN(intervdate, ldDate, ldDate1) READWRITE
>SELECT csrMyCursor
>thisform.grid1.VISIBLE=.T.
>With thisform.Grid1
>
>  .RecordSource = "csrMyCursor"
>  .Columncount = 8
>ENDWITH
>
> COUNT TO thisform.text3.value FOR  survey_num ==1 and BETWEEN(intervdate, ldDate, ldDate1)
> COUNT TO thisform.text4.value FOR survey_num ==2 AND BETWEEN(intervdate, ldDate, ldDate1)
> COUNT TO thisform.text5.value FOR survey_num==3 AND BETWEEN(intervdate, ldDate, ldDate1)
> COUNT TO thisform.text6.value FOR survey_num==4 AND BETWEEN(intervdate, ldDate, ldDate1)
> COUNT TO thisform.text7.value for  survey_num==5 AND  BETWEEN(intervdate, ldDate, ldDate1)
> COUNT TO thisform.text8.value FOR survey_num==6 AND BETWEEN(intervdate, ldDate, ldDate1)
> COUNT TO thisform.text9.value FOR survey_num==7 AND BETWEEN(intervdate, ldDate, ldDate1)
> COUNT TO thisform.text10.value FOR survey_num==8  AND BETWEEN(intervdate, ldDate, ldDate1)
> COUNT TO thisform.text11.value FOR survey_num==9  AND intervdate>=ldDate AND  intervdate<=ldDate1
> count TO thisform.text2.value
>
>thanks
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform