Subject | RE: [firebird-support] SQL Question |
---|---|
Author | Helen Borrie |
Post date | 2007-04-19T09:30:23Z |
At 06:09 PM 19/04/2007, you wrote:
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;
./heLen
>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;
./heLen