I make extensive use of form inheritence. There are a few little quirks, but
nothing I have not been able to work around. I doubt that this problem is
related to form inheritence, but you never know.

Paul Gallagher

----- Original Message -----
From: "René J. Belland" <rbelland@...>
To: <IBObjects@egroups.com>
Sent: Sunday, January 14, 2001 12:32 PM
Subject: Re: [IBO] error code -204


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