Hi,
I think I can answer your second question:

>where (select count(distinct rdtl.pagenumber) from rejectdetail rdtl
> where rdtl.packlineid = pl.packlineid) <> 0

ought to be changed to

where exists (select 1 from rejectdetail rdtl
where rdtl.packlineid = pl.packlineid)

For your first question I guess you somehow have to tell IBO that the field
is generated, but I don't use TIBOQuery myself and hope someone else will
answer this.

HTH,
Set