|Subject||Re: [firebird-support] Newbie Question: Is Firebird SQL really this weird or am I missing something?|
> >select * from test ---> error (table does not exist)it's
> >select * from "test" ---> OK
> >select * from "TEST" ---> ok
> >select * from TEST ---> OK
> >iow, if you see an object containing lowercase characters, then case
> >matters and you have to quote the identifier. Any object in all caps,
> >optional to quote, as long as you stick to all caps.Not at all - simply don't use the double quotes.
> Thanks for clarifying. Guess it's caps-lock:on from now on when using
> ISQL :-)
Database Workbench, a GUI tool to do your Firebird stuff, has "uppercase"
turned ON by default to avoid these problems. You might want to take a
look at www.upscene.com and download yourself a trial version.
Database Workbench - the developer tool for InterBase & Firebird