Using table names with (Firebird) and without (mysql) "

[baurat]

Hi there,

unfortunately I have to support two different database servers: mysql 4.0 and Firebird 1.5.

The application was originally developed for mysql 3.23 with Zeos 5.x.
Table names don't have capitals, for ex. clients.

Now I have the problem that Firebird needs to put all table names in "" if they are not written in capitals:
for Firebird: TZTable.TableName = "clients" , BUT
for mysql: TZTable.TableName = client

Same problem for all queries etc.

I am wondering if there is a possibility from within the zeos components to enclose all table names within a pair of ""..?
Or does anyone have a clue how to write some kind of selector-routine to solve this?

Any help appreciated!

Thanks... Heiko.

[mdaems]

Have you tried this without changes? There is a mechanism provided in Zeos that handles this problem in some cases, I think. If it does not, please, just tell us.

Mark

[baurat]

Hm. It would be a GREAT idea if Zeos would do this automatically. I wil try it again and tell you what happens. Thanks!