Richard,

> What do I need to do to fix this, in "firebird manager" I can see and
> change the data. but when I need to get data by SQL query's it won't work.
>
> SQL> show tables
> CON> ;
> adresses company
>
> coredata coredatacode
>
> glassGroup glassMaterial
>
> glasseSales ocsGlassGroup
>
> ocsSupplier optician
>
>
>
> SQL> select * from optician;
> Statement failed, SQLCODE = -204
>
> Dynamic SQL Error
> -SQL error code = -204
> -Table unknown
> -OPTICIAN
> -At line 1, column 15.

Perhaps you have used double-quotes around the table name
at creation time. If so, you have to use as well whenever
you want to access the table.

select * from "optician";


If there isn't a real necessity to have case-sensitive
table names, then don't use double-quotes for database
object names at creation time. They can be a pain. ;-)


Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com