While it could be hard to read, what is easier, exactly? Here's an example of how it could possibly be made easier to read: However, according to VFP help, 'You cannot place & and a comment after the semicolon used to continue a command line to an additional line.' This is quite definitely false, in VFP 6, 7, and 8. I recall reading somewhere that VFP started supporting that with VFP 6. The example shown doesn't print nicely here on Wiki, and it is overkill in my opinion, but the comment beside 'two' can be most enlightening in later work. As regards 'much harder to read', that is highly debatable and subjective. LastName with 'three' & Person's Last NameĪctually that capability came with FPD 2.6 I believe. MiddleInitial with 'two', & Added Jan 4, 2003 REPLACE FirstName with 'One', & Person's First Name I would advise against it because it makes code much harder to read. It probably worked in some earlier sp's and maybe VFP5, but I'm almost certain not in VFP3) you can add comments on each line of the replace: While upgrading a FoxPro 2.6 app to VFP9, I discovered the comma is NOT needed! And probably hasn't been needed since 2.6 ! Think of how many commas (in bytes) we've wasted! Craig RobertsĪ benefit to this method is that (in VFP6sp5 and newer. I find each part of the command easier to read this way especially when complex expressions are used. I format the command to permit me to reorganize the field sequence if needed.

REPLACE field1 WITH expression1, field2 WITH expression2 REPLACE field1 WITH expression1, field2 WITH expression2 Scope Clauses IN alias If you attempt to REPLACE more than 128 fields in a single command, it will generate a Syntax Error - Mike Yearwood I didn't find this documented in the VFP 7.0 or 8.0 help files or a few other places I looked. REPLACE apparently has a limitation of REPLACEing only up to 128 fields in a single command. and even multiple related tables simultaneously. It can operate on a specified record, the current record, a range of records ( Scope Clauses) or a set of records (FOR Contactdate = DATE()). The REPLACE command lets you fill in a set of fields with specified values.

Foxpro 2.6 commands with example