> Using IBX 4.2 and having created a database using QuickDesk
> administration program, I have table names in lowercase with capital
> letter (i.e. Customers, Employers, etc.).
> When I try to open a TDataSet or a TTable against one of that tables,
> the error "Dynamic SQL error SQL error code = -204 Table unknown
> CUSTOMERS" appears. If I create a table with uppercase name, everything
> goes good.
> It can be a QuickDesk fault letting create a lowercase table name, but:
> a) IB6 lets you doing it, so IBX should get care of it too
> b) IBConsole has no problems in opening the lowercase tables
> c) QuickDesk has no problems in opening lowercase tables too

> Seems that IBX, even if the table name property has right case value
> (i.e. "Employers"), internally converts it to uppercase. It shoud
> perform caseinsensitive... or at least keep the case as specified in the
> property or in the SQL statement (but SQL statement is usually not case
> sensitive on table names... ins't it?).

> Please, give me a quick patch :))
> Marco Menardi

> You did remember to set the SQLDialect for the IBDatabase to 3 instead of the
> default of 1 right?

> "Jeff Overcash (TeamB)" wrote:

> > You did remember to set the SQLDialect for the IBDatabase to 3 instead of the
> > default of 1 right?

> Right. My TIBDatabase has SQLDialect property set to 3. Is there the
> only place to set it? If so I'm right.
> Marco Menardi

> What does your SQL look like?  Are you quoting the table name?  All my testing
> shows that it is still handling cases correctly for dialect 3 DBs.

> Ok, if I quote the table name, then the IBDataset opens correctly, i.e.
> select * from "Ambiti" // WORKS!!!
> select * from Ambiti   // does not work