Thanks Kirk. I was not thinking clearly. -----Opprinnelig melding-----
Date: Sat, 14 Mar 2020 08:29:09 -0700 From: Kirk Brooks <[email protected]> To: 4D iNug Technical <[email protected]> Subject: Re: Query peculiarity in v17? Or normal? Message-ID: <CAHY=xkudgsdbbsxe1efwgmsgs+0uenbh5uihryhzmyrvxkv...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Yes, that's correct. Keep in mind that QUERY([Table2]; [ Table2] Link_T1_ID =[ Table1] T1_ID) evaluates [Table1]t1_id when the line is executed. If there is no current record for Table1 it evaluates to zero so the query is looking for Table2 link fields with a value of zero. On Sat, Mar 14, 2020 at 8:05 AM wangel--- via 4D_Tech <[email protected]> wrote: > I have a Table1 with a field T1_ID, and a Table2 with a field Link_T1_ID. > > All Table1 records have T1_ID values greater than 0. In Table2 several > records may have [ Table2] Link_T1_ID :=0. > > I query Table1 with Table2 where [ Table2] Link_T1_ID :=0: QUERY([Table1];[ > Table1] T1_ID =[ Table2] Link_T1_ID) > > And I get 0 records, as expected. > > I then query Table2 with Table1 where [ Table2] Link_T1_ID equals 0: > QUERY([Table2]; [ Table2] Link_T1_ID =[ Table1] T1_ID) > > And I get all the Table2 records where [ Table2] Link_T1_ID :=0 ( in other > word more records than 0 records). > > Is this as expected when there is no Table1 records where [ Table1] > T1_ID:=0 > ? ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
