Subject Re: [IBO] error code -204
Author Geoff Worboys
> ISC error code 335544569, Sql error code -204,
> Table unknown vxTaxaDistrib
>
> This "table" exists. It is a view. If I set the TIBOQuery
> active property to TRUE in the IDE, there is no error. The
> error appears when I run the app. I have used views in the
> app before and have no problems. Also, I can run the sql
> statement in IB-WISQL with no such error message popping up.
>
> I am using D5, IB5.6, and the latest IBO.

Have you tried running the SQL monitor. It will show you exactly what
SQL is being sent to the server - perhaps that may give a hint.

(I am wondering if the error is occuring while the SchemaCache is
gathering details. Hopefully the SQLMonitor will reveal if this is
the case.)

Geoff Worboys
Telesis Computing