This discussion is archived
6 Replies Latest reply: Apr 4, 2013 11:36 PM by HamidHelal RSS

FRM-40202

875255 Newbie
Currently Being Moderated
I have a form in dev-6i. Form contains following fields with following order.

:CODE
:NAME
:DEPARTMENT

The required property of :department field is YES.
Now on :code field there is a post-change trigger with following code.
insert into a_tab values(:code);
commit;

due to insert command i used commit; but this commit; collapses with :department field's required property YES.
I want to insert the value and I want the same order while the required property of :department is YES.

How to do it?
  • 1. Re: FRM-40202
    HamidHelal Guru
    Currently Being Moderated
    Gul wrote:
    I have a form in dev-6i. Form contains following fields with following order.

    :CODE
    :NAME
    :DEPARTMENT

    The required property of :department field is YES.
    Now on :code field there is a post-change trigger with following code.
    insert into a_tab values(:code);
    commit;

    due to insert command i used commit; but this commit; collapses with :department field's required property YES.
    I want to insert the value and I want the same order while the required property of :department is YES.

    How to do it?
    YOur COMMIT; also save the form entry. Is it okay ?
    Can i suggest you another way ?
    Write your code, i mean insert command at POST-INSERT trigger at block level, also work for you...

    Hope this helps

    Hamid


    Mark correct/helpful to help others to get right answer(s).*
  • 2. Re: FRM-40202
    875255 Newbie
    Currently Being Moderated
    But i have to let this code go on this specific item
  • 3. Re: FRM-40202
    875255 Newbie
    Currently Being Moderated
    is there any other way to commit the command only not the form?
  • 4. Re: FRM-40202
    HamidHelal Guru
    Currently Being Moderated
    Gul wrote:
    is there any other way to commit the command only not the form?
    Yes try
    Forms_DDL('commit');
    Hope this works..

    Hamid

    Edited by: HamidHelal on Apr 5, 2013 12:34 PM
  • 5. Re: FRM-40202
    875255 Newbie
    Currently Being Moderated
    Forms_DDL('commit'); WORKED. THANKS
  • 6. Re: FRM-40202
    HamidHelal Guru
    Currently Being Moderated
    Gul wrote:
    Forms_DDL('commit'); WORKED. THANKS
    Glad i could help. :)

Legend

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