Please send a sample application duplicating this easily.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Riho-Rene Ellermaa" <r.ellermaa@...>
To: "IBObject (ibobjects@egroups.com)" <IBObjects@yahoogroups.com>
Sent: Thursday, September 06, 2001 1:46 AM
Subject: [IBO] Bug in IBO4 AssignSQLWithSearch (IMVHO)


> 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