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