🚀 go-pugleaf

>I need to run a sql flie that uses a variable field. The code is;
>
>SELECT  Cust.CUSTOMER_N, :v.field
>FROM "customer.dbf" Cust, "Variables.dbf" v

I don't know if this can be made to work as you want. However, you could
dynamically build the sql property of the relevant query object, e.g.:

qCust = new query()
qCust.sql := "select CUSTOMER_N," + qVariables.rowset.fields["FIELD"].value
+ ;
" from CUSTOMER"
____
Bowen Moursund (TeamB)
bowen at nerds dot com
http://lonestar.texas.net/~moursund/
Try this help resource:
 http://www.dejanews.com/home_ps.shtml