1 Reply Latest reply: Mar 7, 2013 3:25 AM by HamidHelal RSS

    Record not inserted

    MAHA REDDY
      Hi All,

      I have developed custom form in this form 5 fields is there in one block if i enter the all fields some any values then press the save option it will be saved.
      when one field put null (mean does't enter the value)then press the save option it's not saved.

      forms 10g

      Please give me any solution

      Regards,
      Maha
        • 1. Re: Record not inserted
          HamidHelal
          MAHA REDDY wrote:
          Hi All,

          I have developed custom form in this form 5 fields is there in one block if i enter the all fields some any values then press the save option it will be saved.
          when one field put null (mean does't enter the value)then press the save option it's not saved.
          Hi Maha
          If you think save option in the entire form for all the fields, use Pre-Commit or ON-COMMIT at form level.
          /* sample code for the above trigger */
          IF :COLUMN1 IS NOT NULL AND :COLUMN2 IS NOT NULL THEN
          COMMIT_FORM;
          ELSE
          MESSAGE(' NO ');
          MESSAGE(' NO ');
          RAISE FORM_TRIGGER_FAILURE;
          END IF;
          Hope this works..

          Hamid