Indeed the Uppercase/Lowercase was the problem, if I now rebuild the
database. Thus everything need to be in uppercase (views,triggers,etc etc).

And where do I find doc, about this subject....

But anyhow,.. guys thanks....

Greetz


Richard Drent

Drent IT BV
Laarwoud 11
6718 HZ Ede (Gld)

(0318) 64 79 15 t
(0318) 64 79 45 f
(0651) 33 07 90 m

-----Oorspronkelijk bericht-----
Van: Nando Dessena [mailto:nandod@...]
Verzonden: donderdag 16 oktober 2003 11:34
Aan: firebird-support@yahoogroups.com
Onderwerp: Re: [firebird-support] HOW is this possible, and how to fix

Richard,

SQL>> show tables
CON>> ;
R> adresses company

R> coredata coredatacode

R> glassGroup glassMaterial

R> glasseSales ocsGlassGroup

R> ocsSupplier optician



SQL>> select * from optician;
R> Statement failed, SQLCODE = -204

R> Dynamic SQL Error
R> -SQL error code = -204
R> -Table unknown
R> -OPTICIAN
R> -At line 1, column 15.

you need to understand how delimited identifiers work.
In your case, change your query to

select * from "optician";

If you aren't willing to double quote everything, then don't
use delimited identifiers in the first place when defining metadata.
This may be more or less easy to accomplish depending on the tool you
are using. Some tools will delimit your identifiers by default.

Remember that if you don't use delimited identifiers your identifiers
become case-insensitive and are stored in UPPERCASE by the server.
Then you don't need to double quote them when querying the database.

Ciao
--
Nando mailto:nandod@...



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/