Helen,

> >I'm totally a newbie on Firebird so I'm not sure if I'm doing some
> >banal miskate or what!
> >
> >I created a table named "Persone" and I tryed to exec this SQL
> >statement:
> >"select * from Persone"
> >
> >but I got the following error:
> >
> >Dynamic SQL Error
> >SQL error code = -204
> >Table unknown
> >PERSONE
> >
> >
> >if I create the table naming it "PERSONE", the query above works
> >properly!
>
> 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.

Small mistake: select * from persone - will work just fine if you
used all upper-case characters, even with delimited identifiers.


With regards,

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