Hi 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

Well, it seems you've got bitten by the "Firebird Manager" oddity -
you have been using case-sensitive identifiers, without you know it!

Try: SELECT * FROM "optician"

This is exactly why Database Workbench uses upper-case identifiers
by default!

And, try to do some reading up on case-sensitive identifiers.


With regards,

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