Rene,
KeyRelation is only needed for updateable datasets that have joins - only
one table in a join can be updated and it specifies which table that should
be. So it doesn't have any bearing on the errors you are seeing.

Do you have all the TFields instantiated - I don't know whether that will
help...I have this IBOQuery over a view and it works fine:

object qryNotAssignedInterest: TIBOQuery
Params = <>
DatabaseName = 'Jedi'
IB_Connection = JediMDB
RecordCountAccurate = True
SQL.Strings = (
'select '
'NameCode,'
'MemberName,'
'Status,'
'Email,'
'Interest_Key,'
'Interest'
'from qNotAssignedInterest'
'order by Interest_Key, NameCode')
Left = 128
Top = 360
object qryNotAssignedInterestNameCode: TStringField
FieldName = 'NameCode'
Origin = 'qNotAssignedInterest.NameCode'
Size = 15
end
object qryNotAssignedInterestMemberName: TStringField
FieldName = 'MemberName'
Origin = 'qNotAssignedInterest.MemberName'
Size = 46
end
object qryNotAssignedInterestStatus: TStringField
FieldName = 'Status'
Origin = 'qNotAssignedInterest.Status'
Size = 10
end
object qryNotAssignedInterestEmail: TStringField
FieldName = 'Email'
Origin = 'qNotAssignedInterest.Email'
Size = 75
end
object qryNotAssignedInterestInterest_Key: TStringField
FieldName = 'Interest_Key'
Origin = 'qNotAssignedInterest.Interest_Key'
Size = 4
end
object qryNotAssignedInterestInterest: TStringField
FieldName = 'Interest'
Origin = 'qNotAssignedInterest.Interest'
Size = 50
end

Helen
----------------------------------------------------------------------------
---------------

At 10:12 PM 13-01-01 -0700, you wrote:

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