Home » Developer & Programmer » Forms » master-detail block depepndency
master-detail block depepndency [message #246205] Wed, 20 June 2007 05:10 Go to next message
Messages: 1
Registered: June 2007
Junior Member
Hi, i have master-detail blocks. let they be dept(master),emp(detail) blocks.
i have selected 10 as deptno in dept block, then all employees in 10 will be displayed in emp block. i have changed some employee details.

i tried to change deptno to 20.then when-validate-item executes. i will check for the status of detail block. the status is now changed.
so i will ask user to save or not?
if he wants to save, what code should i write to save?

please let me know code for saving and clearing form in when-validate-item trigger?
Re: master-detail block depepndency [message #246365 is a reply to message #246205] Wed, 20 June 2007 13:38 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
to save - commit_form;
to clear - clear_form;

Re: master-detail block depepndency [message #246399 is a reply to message #246205] Wed, 20 June 2007 15:36 Go to previous message
Messages: 20848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you really need to check that? Oracle will automatically detect that there were changes in a block and offer you to save changes (or not).

Don't code built-in functionalities.
Previous Topic: Where do I get navigator.pll
Next Topic: how to update the records
Goto Forum:

Current Time: Fri Oct 21 06:40:10 CDT 2016

Total time taken to generate the page: 0.08330 seconds