Subject Re: [IBO] Tables Names with Lower Case ... Convert to Upper ?
Author Helen Borrie
At 05:20 PM 3/05/2006, you wrote:
>I have a table created in my early days of Firebird/IBObjects. The
>software I used to create the database allowed lowercase and unaware
>of potential pitfalls I proceeded with the default (lowercase).
>
>Now, following significant development I have a problem having decided
>to use Report Builder End User functionality. RB using daibo.pas
>apparently only recognizes tables without surrounding quotes (").
>
>Is their any way of converting tables with lowercase, surrounded by "
>to Uppercase? It would save me a heap of grief.

This isn't an IBO question...but no, you'll need to recreate the
database without the quotes and pump the data into it. FYI, as an
example, an object defined as "Mike" is not "mike", "MIKE" or any
other combination.

An object defined as "MIKE" will behave like one defined as mike,
MIKE, etc., sans quotes. That's precisely because the database
engine stores all unquoted identifiers in upper case.

Helen