Subject |
ROWSET |
From |
Mustansir Ghor <mustan31@hotmail.com> |
Date |
Tue, 19 Nov 2019 05:13:13 -0500 |
Newsgroups |
dbase.getting-started |
Dear All
I have a parameter query shown below
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?
Best Regards
Mustansir
|
|