Update Fields (Memo) Between two Foxpro Database Tables

Dealing with Memo Fields in FoxPro in not always straightforward especially if you work on an older version of that software (version 6 and version 7) and also if you spent a couple years away from FoxPro.

If you are working on an older version of FoxPro and you are given the task to update a table’s memo field based on another table;  a typical scenario would be that one of your tables got corrupted, you create a new table and you want  to import data from an old backup to the new table.  The script below should help out

 SELECT SourceData
 SCAN
 UPDATE DestinationData;
 SET DestinationData.MemoField = DestinationData.MemoFields + SourceData.MemoField;
    WHERE DestinationData.ID = SourceData.ID
 ENDSCAN
 SELECT DestinationData
 BROWSE


References

HOWTO: Use UPDATE SQL Command to Modify a Second Table
http://support.microsoft.com/kb/191529

Update and Inner Join
http://fox.wikis.com/wc.dll?Wiki~UpdateAndInnerJoin

Visual FoxPro Forum
http://social.msdn.microsoft.com/Forums/eu/visualfoxprogeneral/threads

Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn