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]