> 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
http://www.upscene.com

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

Database questions? Check the forum:
http://www.databasedevelopmentforum.com