🚀 go-pugleaf

In article <6kkokc$cph10@forums.borland.com>, jortner@onramp113.org 
grudgingly admits...
> 
> 
> 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.
> 
You need a PRIVATE variable, not LOCAL to use a &macro.

Private aTable
aTable="ROPE1.DBF"
whatever.SQL= [SELECT * FROM '&aTable.']



-- 
Romain Strieff [TeamB]
Want quick help? Check previous Q and A at:
http://forumsearch.borland.com:88/ and TIs at
http://www.borland.com/VdBASE/vdbprod.html