OraFAQ Forum: Forms » Master Detail Form

Home » Developer & Programmer » Forms » Master Detail Form (Oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Master Detail Form [message #396275]

Mon, 06 April 2009 00:00

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.

Report message to a moderator

Re: Master Detail Form [message #396317 is a reply to message #396275]

Mon, 06 April 2009 02:01

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Master Detail Form [message #396336 is a reply to message #396317]

Mon, 06 April 2009 03:03

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

Report message to a moderator

Re: Master Detail Form [message #396339 is a reply to message #396336]

Mon, 06 April 2009 03:39

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	how to install oracle 6i forms& reports
Next Topic:	how to get user_ip address ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:47:29 CST 2025