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