Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Do while problem
Message
De
03/06/2005 02:12:44
 
 
À
03/06/2005 01:01:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Divers
Thread ID:
01019676
Message ID:
01019685
Vues:
16
Hi Tariq

I would change the second DO WHILE to this:

SELECT VOUCHERS
LOCATE for date=AA and VOU_NO=bb and VOU_TYPE=cc

DO while date=AA and VOU_NO=bb and VOU_TYPE=cc
REPLACE d1 WITH dd

SKIP
ENDDO



>Dear Experts
>
>The following command do nothing and curosr seems to be working for a long time.
>Please make some changes to work
>
>SELECT vou_sum
>GO top
>DO while !eof()
>	AA=date 		&& date type
>	bb=VOU_NO 	&& numueric type
>	cc=ALLTRIM(VOU_TYPE)&& character type
>	dd=d1
>	
>	SELECT VOUCHERS
>	LOCATE for date=AA and VOU_NO=bb and VOU_TYPE=cc
>	DO while FOUND()
>		REPLACE d1 WITH dd
>	ENDDO
>
>	SELECT vou_sum
>	Skip
>ENDDO
>
Benn Kjaer
MS Certified Professional - Visual Foxpro

"There is something rotten in the state of Denmark"
"Why make user-friendly programs, when there aren’t any friendly users :o)"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform