I am getting ( 221): Error SQL: SQLState HYL06: select item 8 must be bound explicitly (302)
on the following sql. I'm new to Baan and 4gl, can someone help me please?

select cisli245.pono,
cisli245.ddat,
cisli245.ityp,
cisli245.idoc,
cisli245.slso,
cisli245.amti,
cisli245.ldai,
cisli245.txah(1)
from cisli245
where cisli245.ityp = :cisli205.ityp and
cisli245.idoc = :cisli205.idoc
order by cisli245.ityp,
cisli245.idoc
Thanks,

R

Hi,

Can you post your complete code? This piece of code looks fine.

My team member helped me get past this. For the field cisli245.txah(1) leave off the subscript in the select statement like this.

select cisli245.pono,
cisli245.ddat,
cisli245.ityp,
cisli245.idoc,
cisli245.slso,
cisli245.amti,
cisli245.ldai,
cisli245.txah
from cisli245
where cisli245.ityp = :cisli205.ityp and
cisli245.idoc = :cisli205.idoc
order by cisli245.ityp,
cisli245.idoc

This compiled fine after this adjustment.
Thanks