Subject RE: [firebird-support] SQL Question
Author Peter Dennis
Hi Helen,

Thanks for both answers. I did the dialect command and got the following:
Client SQL dialect is set to: 1 and database SQL dialect is: 1

Nice to know now what I can and can't do with this particular dialect. Is
it difficult changing the dialect that the database understands? Or could
this mean a possible restructuring of the database? I don't think my boss
will be too interested in me suggesting something too invasive.
I am definitely no expert so don't think I could upgrade it unless it is
fairly simple to do.

Thanks again for your time.


[] On Behalf Of Helen Borrie
Sent: Thursday, 19 April 2007 7:30 PM
Subject: RE: [firebird-support] SQL Question

At 06:09 PM 19/04/2007, you wrote:
>Does that mean it's not possible with this kind of database?

It's not possible to use "illegal" identifiers enclosed in quotation
marks if the database is not dialect 3. So you can't do

SELECT col1 AS "Student Name"

but you can do

SELECT col1 AS Student_Name (but it will output as STUDENT_NAME).

In reply to an earlier question of yours, to find out what the
dialect of your database is, in isql while logged in to the database,
use the command:

SQL> show sql dialect;