RE: [Firebird-odbc-devel] Crystal Reports 8.5

[Kevin S. <ke...@af...>]

Sorry Ann,

Dynamic SQL Error
SQL error code = -104
Token unknown - line 6, char 8
"PATIENT"

I don't know what I was thinking...the query works in IBConsole if I delete
the opening '{oj' and the closing '}'


Crystal Reports 8.5 won't let me edit the SELECT portion of the SQL below.

 SELECT
    	PATIENT1."HOMEPHONE", PATIENT1."MOBILEPHONE",
    	PATIENT1."NAMEFIRST", PATIENT1."NAMELAST", PATIENT1."PATIENTID",
	PATIENT1."PROVIDERID", PATIENT1."WORKPHONE",PROVIDER1."NAME"
 FROM
	{ oj "PATIENT" PATIENT1 INNER JOIN "PROVIDER" PROVIDER1 ON
  	PATIENT1."PROVIDERID" = PROVIDER1."PROVIDERID"}

It appears the ODBC driver doesn't like the '{oj' syntax.  Both EasySoft and
Gemini ODBC process the query correctly.
For the heck of it, I deleted the {oj...}  within Crystal and the query
seems to execute properly.  I'll double-check the result set and let you
know if it causes a problem.


I generated a new report similar to the previous, but specifying the Gemini
ODBC datasource and Crystal generated slightly different SQL:

SELECT
    PATIENT.PATIENTID, PATIENT.NAMELAST, PATIENT.NAMEFIRST,
PATIENT.HOMEPHONE,
    PROVIDER.PROVIDERID, PROVIDER.NAME
FROM
    { oj PATIENT PATIENT INNER JOIN PROVIDER PROVIDER ON
        PATIENT.PROVIDERID = PROVIDER.PROVIDERID}
WHERE
    PATIENT.PATIENTID < 2000
ORDER BY
    PROVIDER.PROVIDERID ASC,
    PATIENT.NAMELAST ASC

This executed properly as is, and also worked when I deleted the {oj...}

Thanks,
Kevin





-----Original Message-----
From: Ann W. Harrison [mailto:aha...@ib...]
Sent: Tuesday, February 19, 2002 10:30 PM
To: ke...@af...;
fir...@li...
Subject: Re: [Firebird-odbc-devel] Crystal Reports 8.5


At 04:36 PM 2/18/2002 -0700, Kevin Smith wrote:

>One more thing.  The statement fails when executed within IB Console as
>well.

"Fails?"  Returns no rows?  Returns an error message?  Crashes the
IBServer process?  Crashes the server system?  Sets the lab on fire?

Ann