Subject | Re: [firebird-support] ISC ERROR CODE:335544665 PK-Constraint in stored procedure, not debug mode!?! |
---|---|
Author | Helen Borrie |
Post date | 2007-01-04T12:47:46Z |
At 07:36 PM 4/01/2007, you wrote:
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.
ensuring that your PK field[s] can never receive duplicate values...
./heLen
>Hello All!Apparently not.
>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!
>And the error doesn't occur in debug mode! Only when I hit the run-"Debug mode" in DBW means that the SP isn't really executing at all -
>Button (green arrow in databas workbench) or when I start the procedure
>with "execute procedure.."
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