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'

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





________________________________
From: Aage Johansen <aagjohan@...>
To: IBObjects@yahoogroups.com
Sent: Sat, August 14, 2010 5:00:06 AM
Subject: [IBO] Re:TCDSProvider does not like TIBOQuery


Hardy wrote:
<<
I have problem using TCDSProvider with TIBOQuery contain Select with Sum(....)
or Select sum(..) group by ....
...

>>

It might help if you posted (more of) the query. Your
select sum(...)
does not require a "group by", but maybe your query/problem is
something totally different?

--
Aage J.







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