1 Reply Latest reply: Apr 26, 2013 2:16 AM by Denes Kubicek RSS

    Value Clear in tabular form when check vaidation& Not get value in Madatory

    Vedant
      Dear Friends

      i am using Apex 3.2 and i am adding invoice Line Using Tabular form and i have apply Mandatory field Validation at Submit Button.
      Proble is when i added 5 invoice line and not enter value into madatory field in one row and press submit then it display me Validation Error Msg and clear all 5 rows.

      I don't want to clear rows values in tabular form column i need that display me error msg but don't clear value of fields.

      how can i do this.

      My mandatory validation code
      begin
      FOR i IN 1.. HTMLDB_APPLICATION.G_F14.COUNT LOOP
        if HTMLDB_APPLICATION.G_F14(i) is null then
          return 'Revenue Type can not be null';
        end if;
      END LOOP;
      return null;
      end;
      Thanks
        • 1. Re: Value Clear in tabular form when check vaidation& Not get value in Madatory
          Denes Kubicek
          Try displaying the validation error on an error page instead on the same page. Don't you think you should upgrade to 4.2? I did that a couple of times from 4.0 and no issues. I don't think there are many people in this forum who can still remember the way 3.2 worked.

          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
          -------------------------------------------------------------------