Thanks Ron, I will reacquaint myself with LTools and experiment with these when I have more time.
Larry On Aug 1, 2014 8:46 PM, "Ron Taylor" <[email protected]> wrote: > Here is a doc that I made to help others with custom scripts in Ltools. > > > On Friday, August 1, 2014 9:04 PM, Larry Lee <[email protected]> wrote: > > > Crossposting. I just saw this after sending my previous post. > Would it be possible for Legacy to provide a tool where these could be > used from within the program rather than LTools? > On Aug 1, 2014 7:49 PM, "Larry Lee" <[email protected]> wrote: > > Ok how do I use these SQL code modules with Legacy? Or are they only used > with Access? It's been 15 years since I used it routinely. > On Aug 1, 2014 6:20 PM, "Jay 1FamilyTree" <[email protected]> > wrote: > > Larry and all, > > I would be willing to help start the files, > but the actual local master and primary admin rights should probably be > somewhere more centrally located, > like an Legacy Wiki page, If they have such a thing. > > Millenia isn' t very current on things like that. > > If anyone has a good suggestion as to where to place the content, let me > know. > > In the meantime I will gather my own little list of often useful SQL > Queries. > > Thanks > > > Jay > > > > > > > > > > > . > > > > On Thu, Jul 31, 2014 at 12:22 PM, Ron Ferguson <[email protected] > > wrote: > > Larry > > LTools has a wide selection of SQL routines. > > Ron Ferguson > > Sent from my Xperia™ smartphone > > Larry Lee <[email protected]> wrote: > > I renamed this to SQL Queries Library. > I know what SQL Queries are but I do not know how they are used with > Legacy and if they would have much demand. Is this something that is > appropriate for only advanced users? > Jay, if you feel this would be useful maybe you could maintain an online > library for these as I doubt Millennia would officially sanction & support > them. > Larry > On Jul 16, 2014 2:24 PM, "Jay 1FamilyTree" <[email protected]> > wrote: > > Ron, > > Not sure why your emails keep ending up in my spam folder.......... > > > Anyway, there is a reason, > Many years ago I had Dennis at LTools create a process to automatically > add spouses and parents to my database. > (see the Create spouses option in LTools) > That worked fine, but as the years have gone by, I realized that the > process was a bit too much. > > I should have limited it to specific descendant lines and not the entire > database. > So, I have these parents out there, most all are UnknownM (Surname) + > UnknownF Unknown that are not really needed, as maybe they are the parents > of an aunt or cousin. > I want to 'trim' those from the database. > > But, some of the parents have a second child married into the database, in > which case I want to keep them > (in order to preserve the relationships) > Hence, the search for parents with only one child. > > Your code worked well and provides a list from which I can use to review > and delete the couple if appropriate. > Which just helps to keep my database relevant and compact. > > > I really wish Legacy would have a central page where the various SQL > queries could be posted for all to share and use. > > Thanks for your help!! > > Jay > > > > > > > > > > > > > > > > > > > On Fri, Jul 11, 2014 at 7:01 AM, Ron Taylor <[email protected]> wrote: > > Jay, > I'm wondering what prompted you to search for this combination. What are > you trying to solve? > Ron Taylor > > > On Wednesday, July 9, 2014 8:33 AM, Ron Taylor <[email protected]> > wrote: > > > This one could be fun. > 1) Clear tag1 > 2) use Legacy>Search>Find>Miscellaneous>Linked individuals with no parents > then click "Clear List before this search" and click "Create List". When > then search results list is displayed, click Options>Advanced Tagging>Tag > and make changes to tag1. Click Everyone in Search List. Now all > individuals without parents have tag1. > 3) Create and save the following query which will be used in step4. Name > it qtblMR_parents_eol > > SELECT DISTINCT tblCR.IDMR > FROM ((tblCR INNER JOIN tblMR ON tblCR.IDMR=tblMR.IDMR) INNER JOIN tblIR > ON tblMR.IDIRHusb=tblIR.IDIR) INNER JOIN tblIR AS tblIR_1 ON > tblMR.IDIRWife=tblIR_1.IDIR > WHERE (((tblCR.IDMR)>0) AND ((tblIR.Tag1)>0) AND ((tblIR_1.Tag1)>0) AND > ((tblMR.IDIRHusb)>0) AND ((tblMR.IDIRWife)>0)); > > 4) Run this query to find the marriage records to answer your question. > > SELECT tblCR.IDMR, Count(tblCR.IDIR) AS Children > FROM qtblMR_parents_eol INNER JOIN tblCR ON qtblMR_parents_eol.IDMR = > tblCR.IDMR > GROUP BY tblCR.IDMR > HAVING (((Count(tblCR.IDIR))=1)) > ORDER BY tblCR.IDMR; > > Let me know if this is what you needed. Note you could tweak the "Having" > number of children as desired. > Ron Taylor > > > On Tuesday, July 8, 2014 8:33 PM, Jay 1FamilyTree < > [email protected]> wrote: > > > I would like to create a report of all parents that only have one child > AND the parents have no father or mother in my database. > > If any great sql coders could help me out, that would be great. > > Thanks > > Jay > > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > <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 > <http://www.legacyfamilytree.com/Help.asp> > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com > <http://news.legacyfamilytree.com/>). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > <http://www.legacyfamilytree.com/LegacyLists.asp> > > > > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > <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 > <http://www.legacyfamilytree.com/Help.asp> > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com > <http://news.legacyfamilytree.com/>). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > <http://www.legacyfamilytree.com/LegacyLists.asp> > > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > <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 > <http://www.legacyfamilytree.com/Help.asp> > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com > <http://news.legacyfamilytree.com/>). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > <http://www.legacyfamilytree.com/LegacyLists.asp> > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > <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 > <http://www.legacyfamilytree.com/Help.asp> > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com > <http://news.legacyfamilytree.com/>). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > <http://www.legacyfamilytree.com/LegacyLists.asp> > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > <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 > <http://www.legacyfamilytree.com/Help.asp> > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com > <http://news.legacyfamilytree.com/>). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > <http://www.legacyfamilytree.com/LegacyLists.asp> > > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > <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 > <http://www.legacyfamilytree.com/Help.asp> > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com > <http://news.legacyfamilytree.com/>). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > <http://www.legacyfamilytree.com/LegacyLists.asp> > > > > 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 > > > > > 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 > 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
