Btw, it returned:

select * from parcel where joborderid=?joborder.id

which was what is in the class really.

May I say again that this worked for a few thousand, but took longer (hours) as the record count grew, and eventually freezed.

Thanks
Dennis