🚀 go-pugleaf

In the following function I am trying to pass the table to use via a
var.  I have tried several different methods, none with success.  What
I would like to do is programmatically chose the table to use with the
query.  I can do this by writing the query for each choice, but that
seems clumsy.  If I could pass the var. for the table then you would
only have to have the query once in the code.  Is this possible?
Thanks for any help you can give.  The query works fine if I just hard
code the table to use.

Jason Ortner




FUNCTION NUMENTRIES
LOCAL thisrope,a
a = 'rope1.dbf'
thisrope = {|a|a}

if _app.curpgec = 1
   cnt = new query()
   cnt.sql = "SELECT HEADFN, HEADLN, HEELFN, HEELLN, DRAWNUM,
DATEOFROPE ;
    FROM 'rope1.dbf' Rope1 ;  //this var. "rope1.dbf" is the one I am
trying to pass.  I have tried more than this scenario, much more.
      WHERE (HEADFN <> '') ;
      AND  (HEADLN <> '') ;
      AND  (HEELFN <> '') ;
      AND  (HEELLN <> '') ;
      AND  (DATEOFROPE = :dt)"
      cnt.params["dt"] = _app.dofrec1  *this param works
      //cnt.params["b"] = thisrope(a)     *this does not
   cnt.active = true
   _app.nrent1 = cnt.rowset.count()
   cnt.active = false
   cnt = null
return