Subject Re: what's the missing link to this grid behavior
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Wed, 13 Apr 2022 09:25:07 -0700
Newsgroups dbase.getting-started

On 4/13/2022 8:59 AM, Dirk wrote:
> Hello,
 >
> when i Filter data, i only get the first row in the grid, by navigation
 > i can continou browsing when datalink grid = vraagbak_Firma.rowset
 >
> when i change the datalink to vraagbak_bezoek i get all the dats of the
> persons in the range , like  date >= 01/01/2015  and date <= "15/01/2021
 >
> using the query bezoek as parent en firma as child
 >
> what i am missing here
 > thanks to put me on right way
 >
> Dirk
 >
> function knop_aanvang_onClick
 >     local dStart, dEinde, volgnr
 >      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_firma.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 order by visit"
 >        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
 >

try after setting your filter:

form.rowset.refreshControls()

You might want to also try checking to see how many rows are in your filter:

    ? form.rowset.count()

and in some cases, I have found that I might be actually at the last
record, so:

form.rowset.first()

Ken

--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm