Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Has REPLACE ALL change in VFP 7?
Message
 
 
To
07/01/2002 02:10:05
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00601408
Message ID:
00601742
Views:
26
>Unless I am mistaking, is it possible the REPLACE function in VFP 7 has changed?
>
>I used to be able to do REPLACE something FOR condition just to test on a single record first. Then, I was issuing REPLACE ALL something FOR condition. But, tonight, I did REPLACE something FOR condition and it replaced all my records.

In addition to what you have already discovered, on an ordered table, say by invoice date, you can use both FOR and WHILE:

SET ORDER TO INVOICE_DATE
SEEK DATE() - 1
REPLACE Price with 30.00 FOR Price = 25.00 WHILE Invoice_Date = Date() - 1
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform