Subject | Re: [IBO] Re:TCDSProvider does not like TIBOQuery |
---|---|
Author | Hardy , |
Post date | 2010-08-16T07:16:01Z |
The following select statement still does not like TCDSProvider, even I have set
Keylinks to Curr_code.
I also have set TIBOQuery, ReadOnly to True
The query generate error message ...Qry_xxx: Field 'Cust_Code' not found
Select Curr_code, sum(AR_Amount) TotAmt
From AccRcv
Group by Curr_code
Having sum(AR_Amount) > 0
table name = AccRcv
Cust_Code = varchar(10) key1
Curr_Code = varchar(3) key2
Ar_amount = numeric 11.3
Any help appreciated
[Non-text portions of this message have been removed]
Keylinks to Curr_code.
I also have set TIBOQuery, ReadOnly to True
The query generate error message ...Qry_xxx: Field 'Cust_Code' not found
Select Curr_code, sum(AR_Amount) TotAmt
From AccRcv
Group by Curr_code
Having sum(AR_Amount) > 0
table name = AccRcv
Cust_Code = varchar(10) key1
Curr_Code = varchar(3) key2
Ar_amount = numeric 11.3
Any help appreciated
[Non-text portions of this message have been removed]