Thanks Helen & Geoff,
I have tried your suggestions and more. Nothing has worked. I tried also
querying a table (not a view) on the db, and that gave the same error. Then
I got desperate and tried using a BDE TQuery -> error message = "missing
sql statement"!
So, it has nothing to do with IBO or BDE. I feel it is related to the
design of the program. I am using embedded forms derived from a base
template. What I don't understand is why I get the error when the
TIBOquery is in a datamodule, or (on the form itself), and thus unrelated
to the form inheritance of the embedded forms.
In any case, I will delve further (or scrap this form architecture....
aaargh). Thank for your help.

René

> >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
> >
> >
>
>All for Open and Open for All
>InterBase Developer Initiative · http://www.interbase2000.org
>_______________________________________________________