Hi Hugh
I have noticed something strange related to the PK index of the table
provided to you.
After having run all the scripts I executed again by chance the first
INSERT statement and VOS allowed me to do it! And I could see both the rows
with ID=0 in the table...
At this point if you delete th
Hi Hugh
Here are the steps to reproduce the problem.
1) Create the table
CREATE TABLE DB.PEST.ANNEXES
(
ANNEXES_ID NUMERIC NOT NULL
, ANNEXES_NAMES VARCHAR(50) NOT NULL
, ANNEXES_PART VARCHAR(1)
, ANNEXES_SPECIAL CHAR(1) NOT NULL
, CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )
);
2) initial