OraFAQ Forum: Forms » Standard.commit

Home » Developer & Programmer » Forms » Standard.commit

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

Standard.commit [message #337428]

Wed, 30 July 2008 20:08

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

Report message to a moderator

Re: Standard.commit [message #337433 is a reply to message #337428]

Wed, 30 July 2008 21:26

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Standard.commit [message #337437 is a reply to message #337428]

Wed, 30 July 2008 21:47

Kevin Meade
Messages: 2103
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

Report message to a moderator

Re: Standard.commit [message #337460 is a reply to message #337437]

Thu, 31 July 2008 00:08

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

Report message to a moderator

Re: Standard.commit [message #339573 is a reply to message #337460]

Thu, 07 August 2008 19:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Good one LF.

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

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 07:07:34 CST 2025