> >select * from test ---> error (table does not exist)
> >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,

it's

> >optional to quote, as long as you stick to all caps.
> >
> >heLen
> >
> >
> Thanks for clarifying. Guess it's caps-lock:on from now on when using
> ISQL :-)

Not at all - simply don't use the double quotes.

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.

With regards,

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