How to Perform REPLACE for Two Databases w/ Common Field (116037)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft FoxPro for Macintosh 2.6a
This article was previously published under Q116037 SUMMARY
To update more than one record in a database from another, similar
database, you may need to check for an end-of-file (EOF) marker during
each iteration of the REPLACE operation. This is best accomplished with
a DO ... WHILE loop, as demonstrated below.
NOTE: In order for this process to work, the two databases must have a
common key field.
REFERENCES
"Language Reference," (Windows and MS-DOS) pages L3-312, L3-470, L3-480, L3-
816, L3-861, L3-1040, L3-1108
"Language Reference," (Macintosh) pages 271, 396, 404, 651, 685, 827, 884
Modification Type: | Major | Last Reviewed: | 10/15/2003 |
---|
Keywords: | kbcode KB116037 kbAudDeveloper |
---|
|