Error Inserting - Record already exist

Applications Forms
#1

Guys, help me solve this problem

This is a Master / Detail Form

  • The Detail Form using an Editable Grid
  • There are no primary key selected in the Detail Form

Whenever i want to insert the 2nd data, it said “Error Inserting - Record already exist”

What does it mean ? How to fix this ?

Thanks

Error Inserting - Record already Exist.jpg

#2

finally, found the problem.

if we want to insert / update to table, that table must have a primary key

#3

In Database design you always need primary keys. Sometimes they get lost in SC which can cause similar errormessages even if on database level your keys are defined. Then you can correct that in the SQL screen.

#4

I see. If i code myself, i usually using delete and insert method instead using update.

Thanks again albert

#5

hi,

have the same problem, error already exist, but using the primary key, and it didnt work.

pls help
thanks

#6

Most likeley your primary key is misconfigured in SC so look at the primary key. Do the right fields have * in front of them? If the error still persists then look into your database as I’m pretty sure you do have a duplicate entry then.