I get error "FieldNo: 16 not found" when I try to open IBOReport.

ConvDM->IB_Query1->Open();
ConvDM->IBOReport->AssignSQLWithSearch(ConvDM->IB_Query1);
ConvDM->IBOReport->Open();

IB_Query:

SELECT ID, accID
, (select account from account a where a.id=m.accid) as accountno
, STATUS , CREATID
, ACCID1
, ACCID2
, SENDSTATUS
, DOCNO
, BREF
, DOCDATE
, INFO
, CURRENCY
, AMOUNT
, RAMOUNT
, RATE
FROM account
join conversion m on account.id=m.accid
where uid=:UID and install=:INST
for update

Calculated field:
REFTEXT varchar(50) CHARACTER SET WIN1252

After vigorous testing I came to conclusion that this problem appeared when
IB_Query contained also Calculated field. Everything worked back in IBO 3.6.

Riho-Rene Ellermaa
senior programmer
Hansabank