isql test:/dodgy.gdb -z
ISQL Version: LI-V1.5.4.4910 Firebird 1.5
Server: LI-V1.5.4.4910 Firebird 1.5,LI-V1.5.4.4910 Firebird 1.5/tcp (test)/P102LI-V1.5.4.4910 Firebird 1.5/tcp (desktop2)/P10
Database: test:/dodgy.gdb, User: sysdba
SQL> show sql dialect;
Client SQL dialect is set to: 1 and database SQL dialect is: 1
SQL> select * from case;
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 15
-case
SQL>

I believe I am using dialect 1 for the connection...

However that got me testing...

SQL> set sql dialect 3;
WARNING: Client SQL dialect has been set to 3 when connecting to Database SQL dialect 1 database.
SQL> select count(*) from "CASE";

COUNT
============

5836

SQL>

Apparently using dialect 3 for the connection to a dialect 1 box works fine!

Thanks

Ian

--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:
>
> > So I think the question still stands. How does the BDE
> > manage to SELECT * FROM CASE in a dialect 1 database?
>
> Using dialect 1 for connection.
>
> SY, SD.
>