Thanks Dennis. I highly recommend LTools to all Legacy users because sooner or later any user who is working with combining files and those sorts of things will likely run into things that LTools will really help fill the gap in using Legacy more fully. Thanks again - your fix worked fine to remove those hundreds of extraneous NAMELESS events.
Jerry - MerriamFamilyTree.org On 9/12/2011 10:31 PM, Dennis M. Kowallek wrote: > 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! > 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
