Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Unanswered: Oracle Developer Forms 6i

    Hi All,

    I have two database blocks, say block A and block B.

    My requirement is, I want to use COMMIT_FORM statement to save the transaction of block A only. This commit should not effect the transaction of block B.

    Thanks in advance.


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    Where's the purpose of doing so? Do you make changes to both blocks? Why would you NOT want to save changes in one of them, while - at the same time - you want to save changes in another?

    If one of the blocks is "view only", you don't have that problem (obviously), so you don't have to worry about it.

    If you make changes to both blocks but want to commit changes separately, separate blocks into two forms.

    Perhaps there is a better solution to your problem; let's hope that someone else knows it.

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    Check out the CLEAR_BLOCK builtin. This will allow you to flush a single block and commit any changes in that block ONLY.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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