Subject | SQLCode -530: Table/Constraint name |
---|---|
Author | João Toledo |
Post date | 2004-07-27T02:14:22Z |
Hi,
Please, look at this piece of code from a SP:
BEGIN
DELETE FROM table1
WHEN SQLCODE -530 DO BEGIN
-> here I want to know the name of the table/constraint
-> who caused the error; is it possible? how?
END
END
I know that -530 is caused due to a Foreign Key, but I have to know
which was the table or the constraint name.
TIA!
João
Please, look at this piece of code from a SP:
BEGIN
DELETE FROM table1
WHEN SQLCODE -530 DO BEGIN
-> here I want to know the name of the table/constraint
-> who caused the error; is it possible? how?
END
END
I know that -530 is caused due to a Foreign Key, but I have to know
which was the table or the constraint name.
TIA!
João