> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Paul Hope
> Sent: Thursday, June 08, 2006 9:32 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO]Parameter values in DeleteSQL
>
>
> HI
>
> I have DeleteSQL of
>
> DELETE FROM SHIPMENTS WHERE
> REC = ? /* OLD_REC */ and
> not exists(select * from shipping_line where shipment=? /*
> OLD_REC */ )
>
> but only the first occurrence of old_rec gets set
>
> EXECUTE STATEMENT
> TR_HANDLE = 24342488
> STMT_HANDLE = 37637208
> PARAMS = [ Version 1 SQLd 2 SQLn 2
> [OLD_REC] = 4176429
> [OLD_REC] = <NULL> ]
>
> Any reason why both shouldn't get set?
>
> Regards
> Paul