SQL error -204 "table unknown" (Delphi 5 Prof / IB open source)

[MatthiasB]

Hi experts,

I have a problem connecting a DBGrid to an InterBase table. DB components used are:
- IBDataSet
- IBTransaction
- IBDatabase

All connected as described in the online help "InterBase Express Reference". When I at design time set IBDataset.Active to true I receive the following:
Dynamic SQL Error
SQL error code : -204
Table unknown
BANK.

The table exists in my local database, it can be used in the editor from IBDataSet.SelectSQL (string stored is "Select * from Bank&quot. Tried now for quite some time, incl. other components, but do not get any further.

Did anyone come across this as well, or has an idea what I possibly do wrong? Any help appreciated - Thanks!

Cheers,
MatthiasB

 

[MatthiasB]

Hi,

found the answer now when talking to a friend: InterBase as of v6 is case-sensitive, and although I preserve case in all codes ('Bank'), somewhere it is translated uppercase by the engine. After rebuilding the DB and making entities/attributes in script generation forced uppercase... it works.

Another case where it is almost too obvious after solution: the error message showed it in uppercase 'BANK'...

Cheers,
Matthias