Thanks Doug, and Arnaud The issue was one or more damaged indexes. After a repair everything seems to be working as it should.
Thanks for the insight into QbF, I'll look into it. Chip On Wed, 3 Oct 2018 09:21:19 -0700, Douglas von Roeder via 4D_Tech wrote: > If you check the checkboxes in the Compatability tab so that Query by > formula uses SQL joins, you can traverse the many to many using Query by > formula. You'll want to run QbF on the server, as well. > > Once that's set up, QbF becomes a very powerful tool. > > Thomas Maul posted a valuable, lengthy message about QbF on the 4D Forum > that extolled its virtues. IIRC, he suggested using QbF if your query had > two or more search clauses. (I've tried to find the posting recently and > not been able to — if anyone finds it, it would be a great post to > link to.) > > -- > Douglas von Roeder > 949-336-2902 > > > On Wed, Oct 3, 2018 at 5:57 AM Arnaud de Montard via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> >>> Le 2 oct. 2018 à 20:10, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> >> a écrit : >>> >>> [...] >>> >>> I ask because it is not, even after a restart of 4D >> >> The doc says it should: >> "The RELATE ONE SELECTION command creates a new selection of records for >> the table oneTable, based on the selection of records in the table >> manyTable and *** loads the first record of the new selection as the >> current record ***." >> >> I'd try something like this: >> >> >> >> QUERY([Sample_Animal_Link];[Sample_Animal_Link]Sample_ID=[Samples]Sample_ID) >> If(found records([Sample_Animal_Link])>0) >> RELATE ONE SELECTION([Sample_Animal_Link];[Animal]) >> If(found records([Animal])>0) >> ASSERT([Animal]primaryKey not empty) >> End if >> End if >> >> Or [Sample_Animal_Link] orphan of animal? >> >> BTW: >> //given a [Samples] selection >> RELATE ONE SELECTION([Samples];[Animal]) >> //Samples..Sample_Animal_Link..Animal >> This use of RELATE ONE SELECTION is not documented but works (or used to >> work, it's a while since I didn't try) >> >> -- >> Arnaud de Montard >> >> >> >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ********************************************************************** > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
