Skip to Content
-5

To avoid adding duplicate key entries to table

Jan 09, 2017 at 10:40 AM

111

avatar image

Hi,

I have created a custom table and there is a field with numc 4. I changed that field to decimal with 2 decimal points. using SE14 i'm going to adjust the table but error occured and stop with error log. then I re enter SE14 and then "unlock table" button clicked and activated my table. After that my table can add duplicate entries to key fields. How to disable adding duplicate entries to key fields of my table??

10 |10000 characters needed characters left characters exceeded

How could it be possible that the database let you add 2 records with same primary key? I can't imagine it could just be a bug! Please give more information about what happens exactly.

2

they are primary key fields.. but it allow duplicate.. I also cann't imagine it.. but it happend. this is an exapmle.. i can add any number of duplicate records with same primary key now..

capture.png (14.2 kB)
0

You should get the key fields and compare them via the debugger (compare tool).

Moreover, make sure the primary index (named ~0) is still there in the database (SE14, index), and create it if it's not there.

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Shailendra Karada Jan 09, 2017 at 01:50 PM
0

Hello Prvithra,

Make that field primary key.

Share
10 |10000 characters needed characters left characters exceeded
Pavithra Jayasinghe Jan 10, 2017 at 03:14 AM
0

they are primary key fields.. but it allow duplicate.. I also cann't imagine it.. but it happend. this is an exapmle.. i can add any number of duplicate records with same primary key now..

Share
10 |10000 characters needed characters left characters exceeded
Sandra Rossi Jan 10, 2017 at 08:33 AM
0

make sure the primary index (named ~0) is still there in the database (SE14, index), and create it if it's not

Share
10 |10000 characters needed characters left characters exceeded