This discussion is archived
1 Reply Latest reply: Apr 26, 2013 12:16 AM by Denes Kubicek RSS

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

Vedant Explorer
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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
    -------------------------------------------------------------------

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points