Home » Developer & Programmer » Forms » Master Detail Form (Oracle9i)
Master Detail Form [message #396275] Mon, 06 April 2009 00:00 Go to next message
mvs_1952
Messages: 11
Registered: March 2008
Location: CHENNAI
Junior Member
I have a form which has a Master-Detail relationship. After data entry the user clicks a button 'Save' to save the record. There are some built in procedures which update certain other tables. To save the record in the form I am using do_key(Commit_form) statement at the end of the trigger 'When Button Pressed'. Occassionally the child record does not get saved. How do I find out that the operation has failed ? Are there amy possibility of preventing such occurance. I am not using any Save Point logics.
Re: Master Detail Form [message #396317 is a reply to message #396275] Mon, 06 April 2009 02:01 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try
standard.commit:
at the end of the procedure instead of (currently used) DO_KEY.
Re: Master Detail Form [message #396336 is a reply to message #396317] Mon, 06 April 2009 03:03 Go to previous messageGo to next message
mvs_1952
Messages: 11
Registered: March 2008
Location: CHENNAI
Junior Member
What is the function of standard.commit ? In what way it is better than do_key ? Can you explain me or give me a link where I can find an article on this
Re: Master Detail Form [message #396339 is a reply to message #396336] Mon, 06 April 2009 03:39 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
STANDARD.COMMIT will do what you've told it to: commit, now, don't ask anything, just commit!

DO-KEY is a built-in which executes built-in subprogram; it is equivalent to pressing the corresponding key on the keyboard.
Previous Topic: how to install oracle 6i forms& reports
Next Topic: how to get user_ip address ?
Goto Forum:
  


Current Time: Wed Dec 07 20:49:53 CST 2016

Total time taken to generate the page: 0.15829 seconds