Hi,

>> Is there a way to store the case of the column names but then to get
>> them without case sensitive feature?
>>
>> For example, I have the "EnterDate" column in a table.
>>
>> If I do "select * from Customers" or I use a report designer, I would
>> like to see the column name as "EnterDate", not "ENTERDATE". (Firebird
>> store all column names in upper case if you do not provide "")
>>
>> I know that I can use the "" in Firebird to keep the case, but then,
>> the column is case sensitive.
>>
>> I would like to store the column name as EnterDate, but then I would
>> need to use EnterDate or ENTERDATE or ENTERDate in the Select or Where
>> clause.
>>
>> Do you know a way to do it?

Don't use "select *", but use column names instead:

select enterdate as "Enter date" from ...

This will showup just as is in your report editor.

Alternatively, create a "report view" for your report-related queries.

create view Report_Customers ("Enter date", ... other columns )
as
select enterdate, other columns
from
...

you can joins etc in the view too, that will simply your report writing.

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