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
_______________________________________________________