4 Replies Latest reply: Aug 2, 2013 4:44 AM by JamesMenzies RSS

    lost LOV values in tabular form after validation fail

    rayanico
      I use Apex4.2 on oracle 11gR2.
      theme: 2
      After selecting checkbox or LOVs in tabular forms when I submit the page and an error raised, all of my checkbox and LOVs where lost but text fields have their values.
      How can I prevent this?
        • 1. Re: lost LOV values in tabular form after validation fail
          Denes Kubicek
          Actually not so easy. You would need to somehow remember the selected values. As far as I know the best way is to use collections but that is not trivial.

          Denes Kubicek
          -------------------------------------------------------------------
          http://deneskubicek.blogspot.com/
          http://www.apress.com/9781430235125
          http://apex.oracle.com/pls/apex/f?p=31517:1
          http://www.amazon.de/Oracle-APEX-XE-Praxis/dp/3826655494
          -------------------------------------------------------------------
          • 2. Re: lost LOV values in tabular form after validation fail
            rayanico
            so it is not possible to get them from session state?
            • 3. Re: lost LOV values in tabular form after validation fail
              Jayson Hanes
              To preserve everything on the page, I'd use an AJAX method of submitting the values (via javascript) and testing their validity in the PLSQL dynamic process -- which can return values that direct what your javascript function(s) does next.. also not trivial but definitely possible (ideally each row would have it's own "update" or "save" button to make this easier)

              OR, more easily done: remove all your apex validations on the page, do not submit the page when the submit button is clicked, but instead, call a javascript function that validates/raises errors.. if all good, THEN submit, if not, show error? (again, not trivial because there could be many values in the tabular form to validate with javascript loops for each row with the checks for whichever columns need validating)
              • 4. Re: lost LOV values in tabular form after validation fail
                JamesMenzies

                Hi

                 

                Any idea on when oracle will be addressing this? Also is the loss of LOV values due to the apex validation or will the database trigger rejecting the row also cause this to happen?

                 

                Cheers