Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement