Home » Developer & Programmer » Forms » forms 10g, win xp 32 bit (problem with key-commit trigger)
forms 10g, win xp 32 bit [message #598066] Thu, 10 October 2013 04:45 Go to next message
Messages: 73
Registered: October 2010
Location: Pakistan
Hi all,

I have a problem with key-commit trigger. I have written some validations and computations criteria on the block level (lines level). Actually there are a number of loops involved in it.

Problem is that the computations are performed twice. (may be the validations would also be performed twice, which couldn't be felt Smile ). can anybody guide me, whats going wrong, since i read somewhere that key-commit is fired on different events, which i infered to be firing only just before database commit.

Re: forms 10g, win xp 32 bit [message #598067 is a reply to message #598066] Thu, 10 October 2013 04:54 Go to previous message
Messages: 12803
Registered: September 2008
Location: Rainy Manchester
Senior Member
Key-commit fires when the user presses the save button, no other time.
In fact it is possible to save data without key-commit firing at all.
If the user makes changes then exits the form then forms will automatically pop up a question asking if they want to save changes. If they click on yes then the data is saved without key-commit firing.
Because of this key-commit is practically useless. You certainly shouldn't be trying to do validation logic in it.
Previous Topic: excel sheet on local machine
Next Topic: How to create folder dynamically using Oracle Form 6i
Goto Forum:

Current Time: Thu Jul 27 23:53:33 CDT 2017

Total time taken to generate the page: 0.14265 seconds