I wanted to clear the block and add new data alert button pressed is 1. It clears the block and allow me to save the new record . But when we requery the old data comes back. What am I missing after clear block. How doe we commit the cleared block .
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
CLEAR_BLOCK(DO_COMMIT) did not work in the first place that is why I changed the code .
This is a master detail block. On one of the items key next item I have an alert . When the alert button is 1 I want to delete the whole details (multi record block) and add new lrecords to the mutli record detail block.
Right now it does clear the record from the block with no_validate .. but when I save the old records are not deleted from the table.
Business Accounts
Answer for Membership
by: flow01Posted on 2009-06-04 at 10:59:20ID: 24549578
NO_VALIDATE Oracle Forms flushes the current block without validating the changes, committing the changes, or prompting the end user.
ASK_COMMIT Oracle Forms prompts the end user to commit the changes during CLEAR_BLOCK processing.
DO_COMMIT Oracle Forms validates the changes, performs a commit, and flushes the current block without prompting the end user.
NO_COMMIT Oracle Forms validates the changes and flushes the current block without performing a commit or prompting the end user.
**************************
So, you are flushing the block , perform a commit on a empty block and query the (same) results.
I suggest you
delete the code-block
Clear_block(no_validate);
do_key('commit_form');
synchronize;
and activate the
Clear_block(DO_COMMIT);
Why did you change that code ?