Subject | Re: [IBO] Re:TCDSProvider does not like TIBOQuery |
---|---|
Author | Hardy , |
Post date | 2010-08-15T09:54:15Z |
I can not use IB_SQL, I use TIBOQuery because i use vcl grid & TCdsProvider to sort grid column when user click on grid's header
On Sun Aug 15th, 2010 1:45 AM EDT Hans wrote:
>IB_SQL gladly accept and properly calculates:
>
>SELECT SUM(QTY_INITIAL) FROM INVENTORY WHERE QTY_INITIAL <> 0
>
>No UniqueKey or and indexed field used, shown plan:
>
>PLAN (INVENTORY NATURAL)
>
>----- Original Message -----
>From: "Helen Borrie" <helebor@...>
>To: <IBObjects@yahoogroups.com>
>Sent: Saturday, August 14, 2010 10:20 PM
>Subject: Re: [IBO] Re:TCDSProvider does not like TIBOQuery
>
>
>> At 12:41 PM 15/08/2010, you wrote:
>>>Hi Helen,
>>>This is typo error on my email, however my TIBOQuery is correct, as
>>>follow.
>>>
>>>Select sum(amount) Tamt from SaleRevenue
>>>where region = 'West'
>>>
>>>
>>>Problem: TIBOQuery looking for the primary key
>>>that is not listed in the select clause
>>
>> It's looking for a unique key, not necessarily the Primary key. A set
>> with only one non-unique field is no use to a client application.
>>
>> Try
>>
>> select sls_id, sum (amount)
>> from SaleRevenue
>> Where region = 'West'
>> group by 1
>>
>> and set the KeyLinks property explicitly to sls_id
>>
>> Note that this is NOT an updatable set so it's possible that the
>> TCDSProvider is set to read-write and is complaining because it cannot
>> establish a key field on which to base a searched update.
>>
>> HB
>>
>>
>>
>> ------------------------------------
>>
>> ___________________________________________________________________________
>> 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
>>
>>
>>
>