Subject | Re: [firebird-support] Bug: Index on "Name" incorrectly indexes on "NAME" |
---|---|
Author | Martijn Tonies |
Post date | 2004-11-27T18:36:26Z |
> > ...Oh, it makes sense. Until you're writing queries :-)
> > 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.
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