Typical problem when mixing products of different suppliers to do the same
job :)

----- Original Message -----
From: "Hardy ," <hardy30@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, August 16, 2010 1:53 AM
Subject: Re: [IBO] Re:TCDSProvider does not like TIBOQuery


I add a newTIBOQuery component then copy the SQL from old TBIOQuery' SQL to
make
sure this is a fresh component
setup the keylinks to Curr_code, set TIBOQuery's ReadOnly to True
Also add a new TCDSProvider and new TDBGrid, set TCDSProvider's ReadOnly to
True

Error still persist, TIBOQuery looking for Cust_code that is not in the
select
list , strange...!

The only way is to remove TCDSProvider and set TDataSource to refer to
TIBOQuery,

this way TIBOQuery work fine Without error message come-up.

I do not want TDataSource to refer to TIBOQuery,
I want TDataSource to refer to TCDSProvider so that when user click on the
Grid
header, then I can sort the column







________________________________
From: Svein Erling Tysvær <svein.erling.tysvaer@...>
To: "IBObjects@yahoogroups.com" <IBObjects@yahoogroups.com>
Sent: Mon, August 16, 2010 2:28:35 PM
Subject: [IBO] Re:TCDSProvider does not like TIBOQuery


My guess is that somewhere in your components (probably within TIBOQuery,
but it
could also be TCDSProvider), there is a reference to Cust_Code.

Do you still get the same error if you create a new project (or add new
components to your existing project), copy the SQL and put Curr_code in
KeyLinks
and elsewhere where TIBOQuery and TCDSProvider wants a unique identifier for
the
dataset? Are you at all referring to Cust_Code somewhere in the components?

HTH,
Set

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of
Hardy ,
Sent: 16. august 2010 09:16
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Re:TCDSProvider does not like TIBOQuery

The following select statement still does not like TCDSProvider, even I have
set

Keylinks to Curr_code.
I also have set TIBOQuery, ReadOnly to True

The query generate error message ...Qry_xxx: Field 'Cust_Code' not found

Select Curr_code, sum(AR_Amount) TotAmt
From AccRcv
Group by Curr_code
Having sum(AR_Amount) > 0

table name = AccRcv
Cust_Code = varchar(10) key1
Curr_Code = varchar(3) key2
Ar_amount = numeric 11.3

Any help appreciated






[Non-text portions of this message have been removed]



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links