Yes. Its a manual referential integrity thing.


_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Jason Wharton
Sent: 09 June 2006 19:40
To: IBObjects@yahoogroups.com
Subject: RE: [IBO]Parameter values in DeleteSQL



Are the column types the same?

> -----Original Message-----
> From: IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com> ps.com

[mailto:IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com> ps.com]On

> Behalf Of Paul Hope
> Sent: Thursday, June 08, 2006 9:32 AM
> To: IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com> ps.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

[Non-text portions of this message have been removed]