Hi Calin

> > about FCombineDuplicateParams - where do you suggest I change it.
> If I recall corectly it is true in only one place.
> Find that place and set it to false.
>
> It should be where the statement is created, otherwise is no good.
>

I found it in IBA_UpdateSQL line 210 and set it to false. This corrected
the probelm I was having with DeleteSQL

delete from forecast_accounts where acno=:old_acno
and company=:old_company
and not exists(select * from rep_forecast f where f.acno=:old_acno
and f.company=:old_company)

I also found it in IBA_Statement.imp and set it to false. This did not cure
the problem with standard SQL. These are the only 2 units where it is set.

Thanks for your help anyway

Regards
Paul