Subject Mastersource an Filter : Grid doesn't follow
From Dirk <non@non.com>
Date Tue, 12 Apr 2022 17:02:22 +0200
Newsgroups dbase.getting-started

good day,

some additional info would be appreciated

i have a question about filtering data with mastersource

: all works perfect with Masterrowset:

now i try out a but with mastersource

i have 4 tables connect with mastersource / params :

  the others stammdat = master

i am filtering as follow:

  when i datalink the grid ( rooster _info) with vraagbak_bezoek : i get
the data of table visit filtered, ok but don't need in this way : an
entryfield gives the date

when i set datalink rooster to stammdat.rowset

i get the data, but when a contact had 10 visit or tel or whatever i get
10 times the name, when i click on it i get the followed name

what's the missing link

Dirk

  function knop_aanvang_onClick
    local dStart, dEinde
     dStart= (form.keuzeveld_begin.value)
      dEinde=(form.keuzeveld_einde.value)
        this.parent.vraagbak_bezoek.params["Start"] = dstart
        this.parent.vraagbak_bezoek.params["Einde"] = dEinde
         this.parent.vraagbak_bezoek.requery()
         this.parent.rooster_info.datalink =
this.parent.vraagbak_bezoek.rowset


  this.VRAAGBAK_BEZOEK = new QUERY(this)
    with (this.VRAAGBAK_BEZOEK)
       left = 210.0
       top = 187.0
       width = 92.0
       height = 37.0
       database = form.databank_klanten
       sql = "Select idnummer, visit, time1, time2  from visit where
visit >= :Start and visit <= :Einde"
       requestLive = false
       params["Start"] = {  /  /    }
       params["Einde"] = {  /  /    }
       active = true
    endwith

    with (this.VRAAGBAK_BEZOEK.rowset)
       onNavigate = class::ROWSET_ONNAVIGATE
       autoEdit = false
    endwith

    this.VRAAGBAK_FIRMA = new QUERY(this)
    with (this.VRAAGBAK_FIRMA)
       left = 126.0
       top = 286.0
       width = 84.0
       height = 37.0
       database = form.databank_klanten
       sql = "select idnummer,name, plz, city, soort, outside from
stammdat  where idnummer = :idnummer"
       requestLive = false
       params["idnummer"] = ""
       masterSource = form.vraagbak_bezoek.rowset
       active = true
    endwith

    with (this.VRAAGBAK_FIRMA.rowset)
       with (fields["soort"])
          lookupSQL = "select segcode, description from segm"
       endwith
       with (fields["outside"])
          lookupSQL = "select  afkorting, name from employee order by name"
       endwith
    endwith