Subject Re: [firebird-support] Case sensitive
Author Martijn Tonies
> > I create a table named "MyTable", via IBOConsole, and when I
> > try open it using SQLQuery (Delphi 7), the dbxpress raised
> > the exception:
> >
> > Table MyTable doesn´t exists !
>
> If you used double quotes (") then yes the table/field names will be case
> sensitive, this is by design to get around use of reserved words.

Get yourself a decent GUI tool that uppercases your names and quotes
reserved words automatically (and warns you if you use a reserved word)
and all your troubles are gone :-)

Hey, I happen to know one ... Database Workbench at www.upscene.com

:-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com