Article ID: 98355 - View products that this article applies to.
This article was previously published under Q98355
The FoxPro UPDATE command allows existing records in a database to be updated from information contained in a second database, based on a common key field between the two databases. The UPDATE command does not allow new records in the second database to be automatically added to the first database. The following procedure can be used to update existing records as well as add new records.
The following procedure uses the UPDATE command to first update existing records. A SELECT SQL command determines which records in the new data file are not contained in the original data file. An APPEND command appends the results of the SELECT command into the original database.
For more information, see the SELECT, SELECT SQL, UPDATE, and APPEND FROM commands in the FoxPro 2.0 "Commands & Functions" manual or the FoxPro 2.5 "Language Reference."
Article ID: 98355 - Last Review: December 3, 2003 - Revision: 2.1