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

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