Variable in sql file

Article View: borland.public.vdbase.data.sql

Article #481

Back to borland.public.vdbase.data.sql Previous Next

#481

From: David M. O'Neil
Date: Sat, 05 Dec 1998 00:00

8 lines
816 bytes

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?

Technical Details

Message-ID: <36695FB7.2CD700E3@ONeilComputing.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,c04ed0e0babc0dba,start
X-Google-Attributes: gidff5a1,public
From: "David M. O'Neil" <David@ONeilComputing.com>
Subject: Variable in sql file
Date: 1998/12/05
Message-ID: <36695FB7.2CD700E3@ONeilComputing.com>
X-Deja-AN: 418977030
Content-Transfer-Encoding: 7bit
Organization: OCC
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql