Subject Re: [firebird-support] ISC ERROR CODE:335544665 PK-Constraint in stored procedure, not debug mode!?!
Author Helen Borrie
At 07:36 PM 4/01/2007, you wrote:
>Hello All!
>I receive this error message while trying to insert data into a table
>with a column with a pk-constraint, allthough the values, wich I want
>to insert are unique!

Apparently not.

>And the error doesn't occur in debug mode! Only when I hit the run-
>Button (green arrow in databas workbench) or when I start the procedure
>with "execute procedure.."

"Debug mode" in DBW means that the SP isn't really executing at all -
it is just being stepped through inside the DBW application to
identify problems in your code.

So check the values that you are passing to your SP that are throwing
the unique key violation.

>Can anyone help me?

Sure, if you provide some information about how you are going about
ensuring that your PK field[s] can never receive duplicate values...

./heLen