Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scan Endscan Problem VFP6 sp3
Message
De
10/01/2000 22:49:39
 
 
À
10/01/2000 22:34:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00315948
Message ID:
00315951
Vues:
27
>>Scan while !eof() for lines=1
lcCusnum=cuskey
lnOrdernum=orderno
lcCatkey=catkey
If lcCatkey="CON" and orderfl.orderno=lnOrdernum
Replace hold with .T. while invfl.orderno=lnOrdernum
Wait window;
"Replaced Hold with True as Requested for Customer # "+lcCusnum;
at 15,115 timeout 0.75
Skip -1
Endif
Endscan<<

Select your primary table before you issue the scan. After your replace statement select your primary table once mode. You don't need the while !eof(), Scan will exit upon the eof, and skip -1. Also, if you an index on invfl.orderno use the For clause.
thanks
oz
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform