The fact that the error only occurs when you run the app, and does not occur
when made active at design time, leads me to believe that it may be some
code or an event triggering the problem. I have been fooled by this scenario
many times. Inherited forms can make it very difficult to track bugs down.

Do yourself a favor and build a demo. Copy the project to a new project, and
delete everything not related to the error. Then start deleting things that
may be related. Through process of elimination, you will find the culprit.
And if not, then it is probably a bug related to form inheritence, or IBO,
but at least you will know what the bug looks like.

I had a bug a while back, that I was convinced was related to form
inheritence, but was not. I spent weeks trying to track it down with no
luck. When I built a demo app for Jason that localized the problem, it
turned out to be incredibly simple. The demo app had one form, one IB_Grid,
one query, and one datasource, all with default settings. The database was
one table, with only three columns, nothing else. It WAS an IBO bug, but it
was so simple, that it gave the "illusion" of being very complicated. I'm
still amazed that it existed as long as it did, with no one else being
bitten by it.

Paul

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@egroups.com>
Sent: Sunday, January 14, 2001 8:04 PM
Subject: Re: [IBO] error code -204


> At 06:19 PM 14-01-01 -0700, you wrote:
> >Datasource located on the embedded form. It is inherited for a base
> >template form, as :
> >
> >inherited srcMainData: TwwDataSource
> > DataSet = dmphytogeogr.qyDistribution
> > Left = 424
> > Top = 85
> > end
>
> And presumably this is the name of the dataset with which you are having
> problems?
>
> Have you tried putting a breakpoint somewhere on the datasource to see
> whether the ancestor is forcing the reassignment of the Dataset property
of
> srcMainData?
>
> And the datmodule's unit is in the uses clause of the form?
>
> Helen
>
>
>
> >Rene
> >
> >At 07:52 AM 1/15/01 +1100, you wrote:
> >
> > >Where is the TDatasource object located? What does it look like when
> > >viewed as text?
> > >
> > >Helen
> > >
> > >
> > >At 11:52 AM 14-01-01 -0700, you wrote:
> > > >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
> > > > > > >_______________________________________________________
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > >
> > >All for Open and Open for All
> > >InterBase Developer Initiative · http://www.interbase2000.org
> > >_______________________________________________________
> >
> >
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
>
>
>