Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do while problem
Message
From
03/06/2005 02:12:44
 
 
To
03/06/2005 01:01:38
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01019676
Message ID:
01019685
Views:
15
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)"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform