Subject | Re: [firebird-support] Handling GDSCODE |
---|---|
Author | Helen Borrie |
Post date | 2005-10-19T05:00:04Z |
At 04:44 AM 19/10/2005 +0000, you wrote:
need to write
WHEN GDSCODE unique_key_violation DO
BEGIN
MSG='.........';
SUSPEND;
BEGIN
There is a full downloadable list of codes, constants and messages in the
Knowledgebase area of the Firebird website.
./heLen
>I'm trying handle GDSCODE but an error occurs when I compile theYup. The PSQL engine expects the constant name for the gdscode, so you
>procedure.
>I wrote
>
>.....
>WHEN GDSCODE 335544665 DO
>BEGIN
> MSG='.........';
> SUSPEND;
>BEGIN
>
>and error -104 ocurred.
>
>Could someone help me?
need to write
WHEN GDSCODE unique_key_violation DO
BEGIN
MSG='.........';
SUSPEND;
BEGIN
There is a full downloadable list of codes, constants and messages in the
Knowledgebase area of the Firebird website.
./heLen