Article View: borland.public.vdbase.data.sql
Article #1003Spaces in Query parameter name?
From: Ted Blue
Date: Wed, 27 May 1998 00:00
Date: Wed, 27 May 1998 00:00
21 lines
1417 bytes
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-mailShow 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