(this is a long post, sorry, but I have to explain the history)
Hi,
I've posted this some time ago, but I received an answer
that do not satisfy me, and possibly others.
What I'm trying to do is:
I have a taable, say TBL1 built like this:
CREATE TABLE TBL1 ( A INT,
B CHAR(4),
C CHAR(3) );
ALTER TABLE TBL1 ADD PRIMARY KEY ( A, B);
Then I add some values to it, via ODBC
INSERT INTO TBL1 (A,B,C) VALUES (1,'aaaa', 'bbb');
INSERT INTO TBL1 (A,B,C) VALUES (2,'aaaa', 'bbb');
INSERT INTO TBL1 (A,B,C) VALUES (3,'aaaa', 'bbb');
INSERT INTO TBL1 (A,B,C) VALUES (4,'aaaa', 'bbb');
INSERT INTO TBL1 (A,B,C) VALUES (5,'aaaa', 'bbb');
It's ok so far.
But a new user of the system tries to insert a value that
already exists:
INSERT INTO TBL1 (A,B,C) VALUES (4,'aaaa', 'ccc');
then the program crashes!
You can say that I didn't treated the error, but I did treat the error,
but the error code I was expecting (23000 - duplicated primary key)
didn't came back. Instead an error message from the SGBD came.
Is there any chance this would be corrected? Anyone else had the same
problem/experience? Any work-around?
If I know more programming, I would correct this, but I can't program.
TIA,
Ricardo.