Subject Re: [firebird-support] GDSCODE. How to write?
Author Helen Borrie
At 05:09 PM 21/09/2007, you wrote:
>I write the following code in psql.
>
>WHEN GDSCODE 335544349, GDSCODE 335544350 DO
>
> BEGIN
>
> INSERT INTO ERROR_LOG VALUES (GDSCODE);
>
> EXCEPTION;
>
> END
>
>
>
>But, Firebird showed: Invalid token.
>
>Dynamic SQL Error.
>
>SQL error code = -104.
>
>Token unknown - line 9, column 18.
>
>335544349.

Use the symbol constant, e.g., these gdscodes are no_dup and no_finish.

You can find the 9-digit codes and their symbols via the
Documentation Index at the Firebird website.
=====================
Please don't hijack other people's threads to start a new
thread. Always start a new thread as a new message.

^heLen