Subject | Re: [IBO] Tables Names with Lower Case ... Convert to Upper ? |
---|---|
Author | Helen Borrie |
Post date | 2006-05-03T08:09:52Z |
At 05:20 PM 3/05/2006, you wrote:
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
>I have a table created in my early days of Firebird/IBObjects. TheThis isn't an IBO question...but no, you'll need to recreate 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.
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