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




________________________________
From: Helen Borrie <helebor@...>
To: IBObjects@yahoogroups.com
Sent: Sat, August 14, 2010 3:24:20 PM
Subject: Re: [IBO] Re:TCDSProvider does not like TIBOQuery


At 03:37 PM 14/08/2010, Hardy , wrote:

>Hi Aage,
>
>My select sum(...) very simple, but yet generate error, the error message very
>strange where it is looking for the primary key
>that is not listed in the select clause
>
>for example I do the following simple select without group by.
>
>Select sum(amount) Tamt
>where region = 'West'

No FROM clause?

>Table
>Sls_id = varchar(10) primary key
>Region = varchar(20)
>Amount = Numeric(13.2)

HB.







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