Subject Re: [firebird-support] Bug: Index on "Name" incorrectly indexes on "NAME"
Author Martijn Tonies
> > ...
> > All that being said, you will slap yourself in the head a couple
> > of times with field names like:
> >
> > "Name" and NAME both in the same table.
> >
> > If not, your boss should do that.
> >
>
> If NAME is just an uppercase shadow of "Name" it makes sense! Maybe too
> clever - one easily trips over things like this.

Oh, it makes sense. Until you're writing queries :-)

select name, "Name"
from ...

Works just fine. Then do things like:
FieldByName('Name') etc...

Very clever. Very confusing :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com