General information
Category:
Coding, syntax & commands
Title:
Do While... Continue Command!!!
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only