Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to save data in details data block without commit?

kareemOct 11 2010 — edited Oct 12 2010
hi all.
i have a form - forms 6i - contains three data blocks h1 DB1 ^(form/master)^ <---DB2 ^(tabular/detail/master)^ <-- DB3 ^(tabular/detail)^

there are some required item in DB1 that must be entered.
user first enter DB1 data then go to DB2 - DB1 master, DB2 detail.
in the normal when we insert new record in the details data block and move cursor to other item the form will ask for commit. i solve this by making commit if the data block status in new or changed, here is the problem because there are some items is required in DB1, so if the user let them empty and fill the tabular data block DB3 the form will make commit and the required item will stored as null in the database.

so, how can i save the data in DB2 and DB3 temporally at the form so that the form will not ask for commit when the cursor changed to other item?
if so , then i can make a procedure that insure that all required filed are entered before do commit.
thanks
This post has been answered by Ammad Ahmed on Oct 12 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2010
Added on Oct 11 2010
7 comments
6,253 views