Home » Developer & Programmer » Forms » Standard.commit
Standard.commit [message #337428] Wed, 30 July 2008 20:08 Go to next message
art_ora
Messages: 10
Registered: May 2008
Junior Member
Hi everyone,

can you difference of standard.commit to ordinary commit/commit_form? and how it is use?

thanks, art
Re: Standard.commit [message #337433 is a reply to message #337428] Wed, 30 July 2008 21:26 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
art_ora wrote on Wed, 30 July 2008 18:08
Hi everyone,

can you difference of standard.commit to ordinary commit/commit_form? and how it is use?

thanks, art


Does any of this relates to Oracle Forms?
Re: Standard.commit [message #337437 is a reply to message #337428] Wed, 30 July 2008 21:47 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
what is STANDARD.COMMIT? never heard of this.

to my recollection, in a forms application, COMMIT and COMMIT_FORM mean the same thing.

Kevin
Re: Standard.commit [message #337460 is a reply to message #337437] Thu, 31 July 2008 00:08 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you have never heard of it, it doesn't mean that it doesn't exist ./fa/1987/0/

Just kidding!

The COMMIT (COMMIT_FORM) statement analyses blocks that exist in a form. If you change a table independently from the declared blocks, then the form doesn't think that it has any changes to save. It usually leads to the "FRM-40401: No changes to save" message.

But, if you use STANDARD.COMMIT, it will bypass any checking and do exactly what you have asked - commit, now!

It is also suggested to use 'standard.commit' (NOT 'commit') in procedures that reside in a form.
Re: Standard.commit [message #339573 is a reply to message #337460] Thu, 07 August 2008 19:11 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Good one LF.

Search this forum for 'standard commit', there are MANY threads.

David
Previous Topic: Behavour of text item like disable
Next Topic: how to create pdf file from d2k report 6i
Goto Forum:
  


Current Time: Sat Dec 10 16:45:36 CST 2016

Total time taken to generate the page: 0.05383 seconds