Subject Re: ROWSET From Heinz Kesting <Nobody@Nowhere.com> Date Tue, 19 Nov 2019 22:57:50 +0100 Newsgroups dbase.getting-started 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