I think this was mentioned before, but be careful with "copy and paste". I
have had some problems with IBO(and other components) when doing this.
Sometimes a TIB_Query component will become "corrupt" and needs to be
deleted and replaced from scratch.

Try building the simplest demo possible to try to simulate the situation.
Sometimes these seemingly complex problems turn out to be extremely simple
when you break it down into the lowest common denominators.

Paul

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


> Thing is.... I can't duplicate this on a regular form. The form I am
having
> probs with is the only one in the whole project designed to use embedded
> forms.
>
> Rene
>
> At 12:37 PM 1/14/01 -0600, you wrote:
> >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
> > > >_______________________________________________________
> > >
> > >
> > >
> > >
> > >
>
>
>
>
>