I assume your TCDSProvider uses the TIBOQuery as its datasource or similar? Yes,
correct




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


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






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