Hi All

I am looking at getting a large application run on Firebird. This application has its roots in Informix and is also currently compatible with MSSQL - all via ODBC.

I have run into a major snag and that is that Active is a reserved keyword in Firebird. It is not so in almost any other database and it does not seem to be part of any Sql spec.

Re-factoring the code to use "ACTIVE" is not an option. There's a lot of code and it already runs on the other RDBMS. It would also immediately impose case sensitivity in a database that is not case sensitive.

Is there any way around this?

Are there any plans to drop active as a reserved word?

Why is active a reserved word when it is not in the sql spec?

Any thoughts highly appreciated.

Cheers

Chris