This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Apr 3, 2013 6:04 AM by 998698 RSS

F10 button

998698 Newbie
Currently Being Moderated
F10 button is not working for saving the data in oracle forms 6i
  • 1. Re: F10 button
    HamidHelal Guru
    Currently Being Moderated
    995695 wrote:
    F10 button is not working for saving the data in oracle forms 6i
    First of all you didn't keep track of your previous two post. If those post requirements end close those thread and mark helpful/correct answer, this will help others to get the solution in same case.

    Now come to your point.
    Most probably you have KEY-COMMIT trigger in your form and you didn't write COMMIT_FORM; in that trigger. So F10 doesn't work.

    Hope this helps


    Hamid

    Mark correct/helpful to help others to get right answer(s).*
  • 2. Re: F10 button
    998698 Newbie
    Currently Being Moderated
    i have written this in Key_commit; trigger on form level then also it is not working.
  • 3. Re: F10 button
    HamidHelal Guru
    Currently Being Moderated
    995695 wrote:
    i have written this in Key_commit; trigger on form level then also it is not working.
    What the error you get ? Press Shift+F1 to display error.
    Take a button in form and at When-Button-Press trigger , write COMMIT_FORM;. Does it works ?

    give us the above question's answer..

    Hamid
  • 4. Re: F10 button
    998698 Newbie
    Currently Being Moderated
    i had already taken one save button which is working fine.

    but when i m pressing F10 button it is not saving data.
  • 5. Re: F10 button
    HamidHelal Guru
    Currently Being Moderated
    995695 wrote:
    i had already taken one save button which is working fine.

    but when i m pressing F10 button it is not saving data.
    How many Key-Commit trigger do you have in your form ? Does all have condition ?If yes, when condition fulfill does you write COMMIT_FORM; ?

    hOPE This helps


    Hamid
  • 6. Re: F10 button
    998698 Newbie
    Currently Being Moderated
    As i told You i have only one KEY-COMMIT Trigger in my Form which is at Form Level and i write commit_form; it that trigger then also it is not working...
  • 7. Re: F10 button
    HamidHelal Guru
    Currently Being Moderated
    995695 wrote:
    As i told You i have only one KEY-COMMIT Trigger in my Form which is at Form Level and i write commit_form; it that trigger then also it is not working...
    Ok. Remove the Key-Commit trigger from forms, don't let if OFF. Than what ?
  • 8. Re: F10 button
    998698 Newbie
    Currently Being Moderated
    i removed the trigger then also it is not working .

    i have one more problem after writing some messages on on error trigger exit button is not working it is showing the messages which i have written on On-ERROR Trigger repeatadly. again and again.
  • 9. Exit Button Not Working
    998698 Newbie
    Currently Being Moderated
    I Will Explain You In Details Regarding Exit Button Not Working.

    I Have Two Text Items Start_date and End_date whose Format Mask is DD/MM/RRRR.

    I want To Suppress the Messages Which Is Coming From Oracle database I use Following Coding on ON_ERROR Trigger Of Start_date Item.


    DECLARE
    lv_errcod NUMBER := ERROR_CODE;
    lv_errtyp VARCHAR2(3) := ERROR_TYPE;
    lv_errtxt VARCHAR2(80) := ERROR_TEXT;
    ALERT_ID NUMBER;

    BEGIN
    IF lv_errcod = 50004 and :BL_DTLS.START_DATE IS NULL then
         clear_message;

              pl_messagebox('AL_CAUTION','Start Date : '||lv_errtxt,'Warning',:GLOBAL.AL_BUTTON,'Y');
    END IF;
         
    IF lv_errcod = 50002 and :BL_DTLS.START_DATE IS NULL then
              clear_message;
                   pl_messagebox('AL_CAUTION','Start Date : '||lv_errtxt,'Warning',:GLOBAL.AL_BUTTON,'Y');
              
    END IF;

    IF lv_errcod = 50026 and :BL_DTLS.START_DATE IS NULL THEN
              clear_message;
                        pl_messagebox('AL_CAUTION',' Start Date : '||lv_errtxt,'Warning',:GLOBAL.AL_BUTTON,'Y');
    END IF;

    RAISE Form_Trigger_Failure;
    END;

    It is working Fine It will suppress all the oracle database messages and showing messages given by me.

    but after pressing an exit buttom it will show my exit alert message but it will show above messages also repeatadely means againg and and exiting directly it will show oracle database related Close Form Message.

    this is the problem pls suggest me ......
  • 10. Re: Exit Button Not Working
    HamidHelal Guru
    Currently Being Moderated
    995695 wrote:
    I Will Explain You In Details Regarding Exit Button Not Working.

    It is working Fine It will suppress all the oracle database messages and showing messages given by me.

    but after pressing an exit buttom it will show my exit alert message but it will show above messages also repeatadely means againg and and exiting directly it will show oracle database related Close Form Message.
    Hi,
    The above situation is true. when you press Exit button, What form do ?
    Form want's to validate all the changes and error occurred and display the message. For the same case it also shows
    database related Close Form Message
    Now
    this is the problem pls suggest me ......
    You have two option either force the user to input valid value in that item or clear the item OR clear the hole form and exit.
    Make your choose.

    For the above reason F10 doesn't work.

    Hope this helps

    Hamid

    Mark correct/helpful to help others to get right answer(s).*
  • 11. Re: Exit Button Not Working
    998698 Newbie
    Currently Being Moderated
    No Hamid ,

    It is not working i m putting clear form on exit button then also it is not working
  • 12. Re: Exit Button Not Working
    HamidHelal Guru
    Currently Being Moderated
    995695 wrote:
    No Hamid ,

    It is not working i m putting clear form on exit button then also it is not working
    try
    Clear_Form(No_Validate);
    hope this works.


    Hamid



    Mark correct/helpful to help others to get right answer(s).*
  • 13. Re: Exit Button Not Working
    998698 Newbie
    Currently Being Moderated
    i did this only man...

    really it is creating so much problem for me
  • 14. Re: Exit Button Not Working
    HamidHelal Guru
    Currently Being Moderated
    995695 wrote:
    i did this only man...

    really it is creating so much problem for me
    If you have Push button in form, then set Keyboard and Mouse Navigation property to NO for all button. and try..
1 2 Previous Next

Legend

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