Subject RE: [firebird-support] GDSCODE. How to write?
Author Pham Huu Le Quoc Phuc
I write:

when gdscode no_dup do

begin

EXECUTE PROCEDURE ATOM_IU(null, null, gdscode);

End



Ibexpert show error: Feature not supported.

What diffents between sqlcode and gdscode, I need use gdscode



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Friday, September 21, 2007 16:08
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] GDSCODE. How to write?



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





[Non-text portions of this message have been removed]