Announcement

Collapse
No announcement yet.

Error Inserting - Record already exist

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error Inserting - Record already exist

    Guys, help me solve this problem

    This is a Master / Detail Form

    Error Inserting - Record already Exist.jpg

    - 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

  • #2
    finally, found the problem.

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

    Comment


    • #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.
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment


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

        Thanks again albert

        Comment


        • #5
          hi,

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

          pls help
          thanks

          Comment


          • #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.
            Albert Drent
            aducom software netherlands
            scriptcase partner, reseller, support and (turn-key) development
            www.scriptcase.eu / www.scriptcase.nl

            Comment

            Working...
            X