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

Remove Gmail “Stay sign in” accounts

If you used the “stay sign in” checkbox in gmail,

you probably realized by now that clearing the cache and clearing the form autofill  data do not delete the “stay  sign” accounts.

The “Stay sign in” passwords are saved under the  “Google Chrome Preferences” windows, specifically under the “personal stuff” tab.

Just locate and delete the ones that you don’t need and Voila.

Where is the Bookmark Bar Google Chrome?

I can’t seem to locate the Bookmark Bar whenever i am using Google Chrome. Its location is too intuitive since i was hoping to find it under Preferences not “Tools” and after spending more than a minute trying to find it on my own (no Google), I decided to write this post to help me remember its location.

Settings --> Tools  -- > Always Show Bookmark Bar

or if you prefer the ShortCut

CTRL + SHIFT + B