[firebird-support] Unique constraint causes insert to fail with 'conversion error from string " "'

2012-11-09 Thread Rick Debay
I have a table T (PBM_CLAIM BIGINT, CLAIM_SRC SMALLINT, ...) with the unique constraint: ALTER TABLE RELAY_CLAIM ADD CONSTRAINT U_RELAY_CLAIM_SRC UNIQUE (PBM_CLAIM,CLAIM_SRC); If I try to insert a row with (NULL, NULL, ...) when this constraint exists, I get the error ISC ERROR CODE:335544334

Re: [firebird-support] Unique constraint causes insert to fail with 'conversion error from string " "'

2012-11-10 Thread Thomas Steinmaurer
> I have a table T (PBM_CLAIM BIGINT, CLAIM_SRC SMALLINT, ...) with the > unique constraint: > > ALTER TABLE RELAY_CLAIM ADD CONSTRAINT U_RELAY_CLAIM_SRC UNIQUE > (PBM_CLAIM,CLAIM_SRC); > > If I try to insert a row with (NULL, NULL, ...) when this constraint > exists, I get the error > >ISC ERR

RE: [firebird-support] Unique constraint causes insert to fail with 'conversion error from string " "'

2012-12-12 Thread Rick Debay
Subject: [firebird-support] Unique constraint causes insert to fail with 'conversion error from string " "' I have a table T (PBM_CLAIM BIGINT, CLAIM_SRC SMALLINT, ...) with the unique constraint: ALTER TABLE RELAY_CLAIM ADD CONSTRAINT U_RELAY_CLAIM_SRC UNIQUE (PBM_CLAIM,CLAI