|Subject||Re: [firebird-support] Re: No case sensitive column names|
> Yes, I tried to use something like create view Report_CustomersWell, case sensitivity is amongst the most evil things in this world :-)
> ("EnterDate", ... other columns )
> 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
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 theWith regards,
> column names always in upper case when you do not specify ""
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum: