Try quoting the entire field, ie.
SELECT
"dailyptf.BrineFlow"
, ...
Cheers,
Carl
-----Original Message-----
From: Derricutt, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 23 May 2000 12:17 PM
To: Multiple recipients of list database
Subject: [DUG-DB]: SQL7 confusion
In the attemps to get my app working with both SQL7 and Access and annoying
changes in SQL, I came accross this little oddity, my application runs the
following query:
SELECT
dailyptf."BrineFlow"
, dailyptf."Enthalpy"
, dailyptf."MassFlow"
, dailyptf."MeasDate"
, dailyptf."Pressure"
, dailyptf."SteamFlow"
, dailyptf."Temperature"
FROM
dailyptf
WHERE 1=1
AND
Object = '6'
AND MeasDate BETWEEN '01-Jul-1999' AND '10-Mar-2000'
But if I try and run it from the Query Analyzer I get:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'BrineFlow'.
Is there a STANDARD way to reference fieldnames in a query that -may-
contain spaces? The query anayzer seems to work if I use
dailyptf.[BrineFlow] but neither double or single quotes work...
And here I thought we had standards for a reason :(
--
Mark Derricutt "People in prayer for me, everyone there for me,
ICQ: 1934853 sometimes I feel I should face this alone, my
Wrk: 377-9941 soul exposed... it calm's me to know that I
Fax: 377-9947 won't!" = Dream Theater - Scarred
DDI: 375-3754
Now Playing: <no audio cd present>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
