🚀 go-pugleaf

On Sat, 05 Dec 1998 11:30:47 -0500, "David M. O'Neil"
<David@ONeilComputing.com> wrote:

>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 want the statment in the sql file to use v.field to select the field
>to be used in customer. I receive the error "Error: Parameter not
>defined: v.field" Is there any way to do this with an sql file?

SQL supports the parameterizing of data values, but not of metadata object
names (tables, columns, etc.). You would need to do as Bowen advised in
another response in this thread: build your statement dynamically, as a
string, inserting the variable value.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                 "What is success in this world? I would say
Technical Publications         it consists of four simple things: to live
INPRISE Corporation            a lot, to love a lot, to laugh a lot, and
http://www.inprise.com/delphi  from it all, to learn a lot."
                                                     -- Richard J. Needham