Subject | Stored procedure and violation of foreign key |
---|---|
Author | szsani |
Post date | 2002-01-24T14:31:58Z |
Hi all,
I have a foreign key working properly. When I want to insert into
Table2 a value which doesn't exists in Table1 my Foreign key doesn'
let me make this operation (I use try except).
But I wrote this into a stored procedure and call it in try except.
This cancels the operation too, but doesn't appears error message,
and program continues running.
Can anyone help me? Where I make mistake?
Thanks in advance
Sandor Szollosi
I have a foreign key working properly. When I want to insert into
Table2 a value which doesn't exists in Table1 my Foreign key doesn'
let me make this operation (I use try except).
But I wrote this into a stored procedure and call it in try except.
This cancels the operation too, but doesn't appears error message,
and program continues running.
Can anyone help me? Where I make mistake?
Thanks in advance
Sandor Szollosi