This discussion is archived
1 Reply Latest reply: Mar 7, 2013 1:25 AM by HamidHelal RSS

Record not inserted

MAHA REDDY Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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

Legend

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