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