Hi,

> > The reason is that you have used the option to create database objects

with

> > quoted identifiers - an option that is available to allow you to use
> > identifiers that contain spaces, or that need to be case-sensitive, or

that

> > are the same word as a reserved word. IBManager might have decided to

do

> > it this way automatically, if it detected that your legacy database had
> > such identifiers in place.
>
> Actually, it's in the Database Registration Info in IBManager.
> There's a check box on the bottom(at least with QuickDesk 2.9) that
> indicates is you want to always capitalize database objects names. If
> you don't select this option by placing a checkmark, then the database
> objects will be created with case sensitive names. I learned this the
> hard way a few years back. By default, it's unchecked and you can't
> change that default in the settings, at least with version 2.9(maybe
> it's possible for 3.0).

In order to avoid these problems, Database Workbench has uppercase
identifiers ON by default :)

I really hate those nasty delimited lower-case identifiers.

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com