Subject ROWSET
From Mustansir Ghor <>
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

   with (this.QSALES.rowset)
      indexName = "item"

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