Sorry, I know nothing about TCDSProvider and cannot be of help, I assume your TCDSProvider uses the TIBOQuery as its datasource or similar?
I know that sorting when clicking the grid header is very easy when using TIB_Query and TIB_Grid (setting things up is a matter of a few mouse clicks), but have no clue as to how to do something similar using your components.

Sorry,
Set

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Hardy ,
Sent: 16. august 2010 09:54
To: IBObjects@yahoogroups.com
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