Home » Developer & Programmer » Forms » master-detail block depepndency
master-detail block depepndency [message #246205] Wed, 20 June 2007 05:10 Go to next message
maddineni81
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: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
to save - commit_form;
to clear - clear_form;

By
Vamsi
Re: master-detail block depepndency [message #246399 is a reply to message #246205] Wed, 20 June 2007 15:36 Go to previous message
Littlefoot
Messages: 21823
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: Thu Dec 05 00:23:02 CST 2024