Commit not commiting to the database tilll we exit the form
We are using Forms 6i.
I have been developing Forms since 10 yrs but never had this problem.
I have a form in which I have added a button to update a table.The code for the WHEN BUTTON PRESSED trigger is updating the table and doing a COMMIT.
When the user presses the button, I can see there is a lock on the table being updated. But the data is not updated in the database yet.
So I put the code on another button which has COMMIT and EXIT_FORM. When I press this button the data is commited.