Hi,

Here is the output from the monitor. The statement is exactly the one that
works otherwise.
Question: Do I have to have a value in the KeyRelation property? I have not
done so in other queries that use views, and it works. This view differs
in that I have not used the "JOIN" syntax. Also, there is no schema cache
value in the schemacachedir of the TIBODatabase component.

Thanks,
Rene

*******************************BEGIN**********************

PREPARE STATEMENT
TR_HANDLE = 15878096
STMT_HANDLE = 15878168

select taxonID, geocode, VARIETY, SUBSPECIES,
SUBSPPAUTHOR, AUTHOR, SPECIES, VARAUTHOR
from vwTaxaDistrib


FIELDS = [ Version 1 SQLd 0 SQLn 8 ]

SECONDS = 0.010

ERRCODE = 335544569
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15878096
STMT_HANDLE = 15878168

select taxonID, geocode, VARIETY, SUBSPECIES,
SUBSPPAUTHOR, AUTHOR, SPECIES, VARAUTHOR
from vwTaxaDistrib

FIELDS = [ Version 1 SQLd 0 SQLn 8 ]

ERRCODE = 335544569
----*/
/*---
INTERPRETE BUFFER =

ERRCODE = 17
----*/
/*---
INTERPRETE BUFFER = Dynamic SQL Error

ERRCODE = 21
----*/
/*---
INTERPRETE BUFFER = SQL error code = -204

ERRCODE = 13
----*/
/*---
INTERPRETE BUFFER = Table unknown

ERRCODE = 13
----*/
/*---
INTERPRETE BUFFER = VWTAXADISTRIB

ERRCODE = -1
----*/
/*---
COMMIT
TR_HANDLE = 15878096
----*/

************************************END**************************



At 03:40 PM 1/14/01 +1100, you wrote:

> > 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