|Subject||Re: [firebird-support] Trapping Foreign Key violations in SQL|
>Use CONSTRAINT on your foreign keys, to give them a unique name. Something
>YourField YourFieldType CONSTRAINT Name_Here REFERENCES
>This way you can parse the message to get the constraint name.
I have already named the constraints - how do I get the message text in
SQL? It's easy enough to write :
WHEN SQLCODE -803 DO EXCEPTION xyz
but how do I get the associated text in a Stored Procedure?
Thanks in advance,
[Non-text portions of this message have been removed]