Subject Re: [firebird-support] Re: No case sensitive column names
Author Martijn Tonies
> Yes, I tried to use something like create view Report_Customers
> ("EnterDate", ... other columns )
> as
> select enterdate, other columns from
> for the report designers, the problem is some users do not respect the
> case and they enter as a filter the column name using upper case or
> all lower case. For example ENTERDATE='1MAY08', others do
> enterdate='1MAY08'.

Well, case sensitivity is amongst the most evil things in this world :-)

Don't you have a "display name" available in your report writer
instead of the "name" of the column?

Who would want something named "EnterDate" anyway, as opposed
to "Enter date"?

> I think that there is no solution in FB simply because FB stores the
> column names always in upper case when you do not specify ""

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: