Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scan Endscan Problem VFP6 sp3
Message
From
10/01/2000 22:49:39
 
 
To
10/01/2000 22:34:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00315948
Message ID:
00315951
Views:
30
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform