Hi Helen,

>And presumably this is the name of the dataset with which you are having
>problems

Yes it is. But I have tried with other datasets and get the same error.
Somewhere in this string of messages, I mentioned this (in response to
Geoff I think).

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

No, but.... my sql statement seems to arrive intact to server as viewed by
the IBO sql monitor. Geoff suggested that I check this out in one of my
earlier posts.

>And the datmodule's unit is in the uses clause of the form?

Yes it is.

At this point, I am going to reconstruct some of the queries etc as
suggested by Paul Gallagher. I had done some cut & paste of the IBO
components, and Paul said that this sometimes causes problems.

Thanks for your help & suggestions. This list is certainly one of the best
I have ever joined. Between yourself, Geoff, Claudio, Paul, Jason [of
course :-) ] and many others, it really is a great support group.

Cheers,
René

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