Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do While... Continue Command!!!
Message
From
13/02/2003 20:35:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Do While... Continue Command!!!
Miscellaneous
Thread ID:
00753026
Message ID:
00753026
Views:
54
HEy Guys can you help me with this..

I have a code that suppose to locate for everything that matches the value of a combo box. I used the Do while..Continue command, but it only finds 3 records out of four records or four out of five records and so on.... It usually did not find the first match record. My syntax is this...

SELECT PRINT_COST && table to be search

LOCATE FOR ALLT(THISFORM.COMBO1.VALUE)=ALLT(PRINT_COST.BUWAN)
DO WHiLE !EOF() && begins my loop

** If found a match it should append the other table with the values of ** other table

CONTINUE
IF FOUND() THEN
SELECT PRINT_PERA
APPEND BLANK
REPLACE PRINT_PERA.BUWAN WITH PRINT_COST.BUWAN
REPLACE PRINT_PERA.ITEM WITH PRINT_COST.ITEM
REPLACE PRINT_PERA.ADM WITH PRINT_COST.ADM
REPLACE PRINT_PERA.ACC WITH PRINT_COST.ACC
REPLACE PRINT_PERA.SCS WITH PRINT_COST.SCS
REPLACE PRINT_PERA.SSD WITH PRINT_COST.SSD
REPLaCE PRINT_PERA.FDD WITH PRINT_COST.FDD


SELECT PRINT_COST
ENDIF
ENDDO


PLease correct my Codings....

Thanks and God Bless!!

V_E_R
Next
Reply
Map
View

Click here to load this message in the networking platform