6 Replies Latest reply: Apr 5, 2013 1:36 AM by HamidHelal RSS

    FRM-40202

    875255
      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
          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
            But i have to let this code go on this specific item
            • 3. Re: FRM-40202
              875255
              is there any other way to commit the command only not the form?
              • 4. Re: FRM-40202
                HamidHelal
                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
                  Forms_DDL('commit'); WORKED. THANKS
                  • 6. Re: FRM-40202
                    HamidHelal
                    Gul wrote:
                    Forms_DDL('commit'); WORKED. THANKS
                    Glad i could help. :)