Subject | RE: [IBO]Parameter values in DeleteSQL |
---|---|
Author | Paul Hope |
Post date | 2006-06-12T10:23:57Z |
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?
_____
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-----[mailto:IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com> ps.com]On
> From: IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com> ps.com
> Behalf Of Paul Hope[Non-text portions of this message have been removed]
> 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