On Mon, 12 Sep 2011 21:57:53 -0400, Jerry <[email protected]> wrote:
>Oh, of course, I'd love to be able to delete all these extraneous event >records. That's why I posted about this several weeks ago, but at that >time I got no helpers. I went back and looked but couldn't spot your original request. Maybe it wasn't plain text. ;-) Make a backup of your database. Then run this query... DELETE * FROM tblER WHERE tblER.IDET=1 It should delete about 607 rows. If any of these events have sources or pictures assigned to them it might leave them dangling. Don't know if Check/Repair will clean these up. There is a way to make sure these danglers won't occur but it is a little more complicated. It involves adding back the Record Changed event type (and tag it after untagging all others), getting its IDET (say it's 60), then updating all the IDET=1 to IDET=60. Finally you use LTools "Delete Master Events" to remove the Record Changed event and anything else that is pointing to it. Good luck! -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools NOTE TO LUG USERS: Use plain text if you want me to read your post. Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
