Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2011
    Posts
    8

    Unanswered: How to avoid Oracle Form to perform commit action ?

    I have a question.

    The case is: After a user correct some data displayed in text items, he needs to click a button to update the record.

    However, the oracle form the commit the update action.

    I don't want to allow Oracle Form to perform commit UNTIL the user closes the oracle form.

    Is it possible to do so?

    If yes, I should use what kinds of Trigger to realize this.

    Thanks a lot.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    he needs to click a button to update the record. However, the oracle form the commit the update action.
    This might be the case only if WHEN-BUTTON-PRESSED contains COMMIT. Obviously - remove COMMIT from that trigger.

    I don't want to allow Oracle Form to perform commit UNTIL the user closes the oracle form
    That's rather strange. Normally, when you go out form a form, you don't really want to save changes you made. Anyway: from what you said, KEY-COMMIT would be "NULL;" while KEY-EXIT would be "COMMIT; EXIT_FORM;". Now you should explain how do you plan to let users exit the form WITHOUT saving changes they made? KEY-EXIT won't work, obviously, as it will COMMIT those changes. Eh? A problem?

    From my point of view: COMMIT should be done by user, explicitly by pressing the "Save" button. It means that user is aware of what he/she does, meaning: "Yes, I'm sure I want to commit". Pressing the EXIT button opens an alert, asking the user whether he/she wants to save changes, doesn't want to do that, or cancel the EXIT action. That's by default, and Oracle did it well.

    Why exactly do you want to change that functionality?

  3. #3
    Join Date
    Sep 2011
    Posts
    75
    Quote Originally Posted by programmingnewbie View Post
    I have a question.

    The case is: After a user correct some data displayed in text items, he needs to click a button to update the record.

    However, the oracle form the commit the update action.

    I don't want to allow Oracle Form to perform commit UNTIL the user closes the oracle form.

    Is it possible to do so?

    If yes, I should use what kinds of Trigger to realize this.

    Thanks a lot.
    Hello,

    Remove the commit statement

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •