Subject Re: ROWSET
From Mustansir Ghor <mustan31@hotmail.com>
Date Wed, 20 Nov 2019 01:52:45 -0500
Newsgroups dbase.getting-started

Dear Heintz

Thank you. Thats what i did shifting to plan B. It is working. But it took me 2 days to shift to plan B.

Regards
Mustansir

Heinz Kesting Wrote:

> Hi Mustansir,
 >
> >
> >    this.QSALES = new QUERY(this)
 > >     with (this.QSALES)
 > >        left = 4.0
 > >        database = form.dpos
 > >        sql = "select * from SALESI where sno=:msno"
 > >        params["msno"] = ""
 > >        active = true
 > >     endwith
 > >
> >     with (this.QSALES.rowset)
 > >        indexName = "item"
 > >     endwith
 > >
> > In a function I set the parameter and requery it. From the resultset when i use rowset.finkey() method , it does restrict to resultset but search the whole table.
 > >
> > Does it function this way?
 >
> I can't say for sure if this WAD. At least where I had been working with
> DBF tables I never experienced this behaviour.
 >
> You could try to replace the findKey() with applyLocate(), it should
> make no difference in speed on an up-to-date machine as long as your
> rowset is not too big (chances are good for a modest-sized rowset after
> the requery() command) - does that help?
 >
> Kind regards, Heinz