Announcement

Collapse
No announcement yet.

[SOLVED] V7.001 problems with MYSQL last_insert_id

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

  • [SOLVED] V7.001 problems with MYSQL last_insert_id

    Hello,

    again there are problems with the last id of an inserted record in a mysql database.


    Example :
    Primary key of a table is {record_id}

    In the OnAfterInsert event of a form in V6 the value {record_id} contains the last created value of the inserted record in mysql.
    In V6 no problem .. in V7 {record_id} returns 0 !!!

    The primary key of the table is defined as integer - autoincrement.

    I posted this bug to support BEFORE 3 DAYS (PAID SUPPORT) BUT GET NO ANSWER. THAT'S NOT FUNNY.

    Regards
    Uwe Pfeiffer

  • #2
    Hello,

    Please send me a pm with the ticket ID.

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

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Hi Pfeiffer,
      I dont have problems getting the last id in sc7, here is an example with 2 ways to get the same result:
      Screenshot
      http://goo.gl/NryYL


      Example to get Last insert id
      PHP Code:
      sc_lookup(rs"SELECT LAST_INSERT_ID()");
      echo 
      "SC LastID:".{your_field_id};
      echo 
      "MySQL LastID:".{rs[0][0]}; 
      Last edited by hirambq; 02-15-2013, 05:55 PM.
      Best Regards
      Hiram BQ

      Comment


      • #4
        Hello,
        you are right. The problem was caused by the problem with upload files.. so my id was 0. But this is a problem depending on upload error.
        So SC V7 is handling last_id correctly.. thank's for your answer.

        Regards
        Uwe

        Comment

        Working...
        X