how to save data in details data block without commit?
kareemOct 11 2010 — edited Oct 12 2010hi 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