Chip: "The issue was one or more damaged indexes. After a repair everything seems to be working as it should." Glad you tracked it down quickly.
"Thanks for the insight into QbF, I'll look into it." It's handy. A couple of years ago, just for G&G, I used QbF to support typeahead searching in a system whose primary function is creating proposals, line items, and option items. For each table, the code would QbF over a handful of "high value" fields but it would also find proposals based on values in the line items/option items. The trick was to Seq query destination into local sets and then do set operations as the code iterated. Turned out quite nicely - instantaneous results in a system with 30k ± proposals and about 1MM line items/option items. -- Douglas von Roeder 949-336-2902 On Wed, Oct 3, 2018 at 9:44 AM Chip Scheide <4d_o...@pghrepository.org> wrote: > 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 **********************************************************************