Hope it's clear to you
NO_VALIDATE: Oracle Forms flushes the current block without validating the changes, committing the changes, or 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.
Thanks for the response, I appreciate it, and hopefully this next question wont sound stupid, though it probably is a stupid question lol. Ok so I have just pressed cancel on my detail block which has: flushed the detail block without validating the changes, committing the changes, or prompting the end user. I then go to my master block and make changes and save them. Since my detail block has been flushed and all data cleared when I commit my changes from my master block am I committing the cleared down values (ie, null values) from the detail block?
Nothing will save or commit on that block for the corresponding master record. Any change on master will save if you not clear the master record as well.