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
|
|