Hi,

> > > I bet you've reported something wrong here.
> > >
> > > If you create the table as "PERSONE" then both of the following will

work:

> > >
> > > select * from "PERSONE";
> > >
> > > select * from PERSONE;
> > >
> > > but select * from persone **won't** work.
>
> At 12:52 PM 18/09/2003 +0200, Martijn wrote:
>
>
> >Small mistake: select * from persone - will work just fine if you
> >used all upper-case characters, even with delimited identifiers.
>
> Right! I just confirmed that in 1.5 (didn't disbelieve you, of course!)
>
> Now - do you, or does any other viewer out there have a "playabout"

dialect

> 3 database on a rls 1.0.x server, that you could test this out on?
>
> That is, something like the following
>
> CREATE TABLE TEST_ME (
> "PERSONE" INTEGER);
> COMMIT;
>
> INSERT INTO TEST_ME (persone)
> values(99);
>
> That's all - just to verify that it works the same in 1.0.x. (which right
> now I don't have on any of my servers because of Other Needs, testing

RCs).

>
> This test, btw, is for The Book, which has to cover both 1.0 and 1.5.

Confirmed - that it works, that is. :-)

As said - if you use all uppercase, it works fine as long as you're not
using keywords (like "TYPE").

Nevertheless, please write in the book that people should avoid using
delimited identifiers :-)


With regards,

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