DOCERR: Note in REPLACE Command Documentation Is Misleading

 Last reviewed: November 9, 1995
Article ID: Q139062
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, version 3.0

SUMMARY

The Note in the REPLACE command documentation describes a limitation that in fact does not exist in Visual FoxPro. The incorrect note states: 

   No replacement occurs if the record pointer is at the end of the file
   in the current work area and you specify a field in another work area.
It is possible to replace a field in another work area if the pointer is at the end of the file in the current work area by using the REPLACE command with the IN clause as in this example: 

   REPLACE <Fieldname>  WITH  <Varible>  IN  <TableAlias >

MORE INFORMATION

The REPLACE command will not work if the pointer is at the end of the file in the table where the replacement is supposed to occur no matter where the pointer is in the current table.

Sample Code

Run the following code from the Visual FoxPro Command window.

SET DEFAULT TO C:\VFP\SAMPLES\DATA OPEN DATA testdata USE products IN 0 

GO TOP       && Move record pointer to the first record
USE customer IN 0 SELECT customer GO BOTTOM 
SKIP         && Now the current work area(customer) is at EOF
REPLACE Eng_name WITH "John Doe" IN products

Browse the products table, and note that Eng_name has been changed to John Doe contrary to what the documentation says.

Additional reference words: 3.00 VFoxWin
KBCategory: kbprg kbcode kbdocerr
KBSubcategory: FxotherGeneral

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 9, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.