Menu ▾ ▴

#384 function sequence error when trying to edit employee record

v4.1
open-postponed
Andrew Heard
Functionality (69)
6
2011-06-23
2011-06-17
Erik Grandy
No

Test 30 step 3 should have a Floating panel loaded with entry containing all information from record with the 'empno' field greyed out but instead a 'Function sequence error' message is displayed.

Discussion

  • Paul Johnson

    Paul Johnson - 2011-06-21
    • priority: 5 --> 6
     

  • Andrew Heard

    Andrew Heard - 2011-06-22
    • assigned_to: nobody --> andrewheard1
     

  • Andrew Heard

    Andrew Heard - 2011-06-23

    The row can be correctly updated if the error is ignored so for beta 1 we will add a special case when the HY010 error is received. This is done in the checkForRowReturnError in the DBStatement_IBM_DB2.php file.

    This will need to be revisited in order to determine the underlying cause of the error.

     

  • Andrew Heard

    Andrew Heard - 2011-06-23
    • milestone: 2022244 --> v4.1
    • status: open --> open-postponed
     

  • Peter Prib

    Peter Prib - 2011-06-24

    I spent hours trying to find the bugs due to the HY010 being ignored and extensively rewrote IBM_DB2.php to handle the issue. Now you have re-introduced this major bug.

    Could I suggest not generically allowing invalid return codes. This is not good programming practice and may introduce unexpected issues. Could I suggest that you back out the code change. If a specific call requires certain error(s) ignored it should pass on the call.

     

  • Paul Johnson

    Paul Johnson - 2011-06-25

    This temporary fix will not be committed to the dev branch, only TEr4. After beta1 we will fix the underlying problem which causes edits on the sample employee table to fail.