🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Spaces in Query parameter name?

#1003
From: Ted Blue
Date: Wed, 27 May 1998 00:00
21 lines
1417 bytes
I cannot seem to create a query parameter using a field name that
contains any spaces. This is needed to establish a master-detail link
between two tables using the query.masterSource SQL statement. The
following variations do not work:

  select * from lineitem where lineitem.'invoice id' = :invoice id

  select * from lineitem where lineitem.'invoice id' = :'invoice id'

  select * from lineitem where lineitem.'invoice id' = ::invoice id:

Note that the quotes and explicit table reference work in the WHERE
clause, but the parameter name will not work. Fails with various
messages, including 'Invalid use of token: ID' and others. Also note
that these tables are the tables included in the MUGS database, all of
which are constructed with key fields that have spaces in their names
(this is also true of the FLEET database). Any help would be
appreciated.

Ted
Technical Details
Message-ID: <356C5B16.2057@bluestarcorp.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,14c6ee05b6d488f4,start
X-Google-Attributes: gidff5a1,public
From: Ted Blue <tedblue@bluestarcorp.com>
Subject: Spaces in Query parameter name?
Date: 1998/05/27
Message-ID: <356C5B16.2057@bluestarcorp.com>
X-Deja-AN: 357051995
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Reply-To: tedblue@bluestarcorp.com
Content-Type: text/plain; charset=us-ascii
Organization: Blue Star Training and Software, Inc.
Newsgroups: borland.public.vdbase.data.sql