>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