Announcement

Collapse
No announcement yet.

[SOLVED]Editing a Primary Key field Error

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

  • [SOLVED]Editing a Primary Key field Error

    When trying to edit a field that is a primary key I receive an error message from scriptcase stating "Error updating database, record not found". However, when I click the Cancel button the change I tried to make saves without error.

    The field is set to be able to edit/update in the database. I also can update it without error through phpmyadmin. I am running a mySQL database version 5.5.16. Please help Thanks!

  • #2
    Re: Editing a Primary Key field Error

    Hello,

    I have just reported this issue to our bugs team for further testing.

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Re: Editing a Primary Key field Error

      Any word on this one yet? Thanks

      Comment


      • #4
        Re: Editing a Primary Key field Error

        Hello,

        I have contacted our development team asking for the bug status. If you wish, you can also open a ticket on our support system to get more frequent updates regarding the bug.

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Re: Editing a Primary Key field Error

          Hello,

          After contacting our development team I found out that it is actually SC that doesn't allow updates on primary keys.

          I have also sent as a suggestion that forms should update primary keys. If you wish, you can also send the suggestion to suggestion@scriptcase.net

          regards,
          Bernhard Bernsmann

          Comment


          • #6
            Re: Editing a Primary Key field Error

            Thank you for your help and information

            Comment


            • #7
              How Can i assign a value to a filed that is primary key?

              I have a form with 2 fields as primary key (filed1 and field2), field1 is a foreing key for my form master-detail and field2 is a field that count the records created.
              For example:
              Master
              field1
              1

              Detatil
              field1 field2
              1 1
              1 2
              1 3

              The question is how can i generate the value for field2? (i tried onbeforeinsertrecord) assign a value through of a function, but SC not alow do it.

              Comment

              Working...
              X