Home » Developer & Programmer » Forms » 'COMMIT_FORM' TRIGGER (OS:LINUX.)
'COMMIT_FORM' TRIGGER [message #403006] Wed, 13 May 2009 07:44 Go to next message
Messages: 1
Registered: May 2009
Junior Member
Hello everyone...
I need an advice
im writing this code and when im saving my forms there is a call for COMMIT_FORM
after that call a null value is inserted into one of the forms fields...i cant find where in my code its happening.

does someone know what could it be?
or maybe what triggers are being called when i use the line COMMIT_FORM?

thanks for your help and time.
eitan Laughing
Re: 'COMMIT_FORM' TRIGGER [message #403013 is a reply to message #403006] Wed, 13 May 2009 08:13 Go to previous messageGo to next message
Messages: 12820
Registered: September 2008
Location: Rainy Manchester
Senior Member
Lots of triggers can fire when you commit a form.
For example:
any outstanding WHEN-VALIDATE-ITEMs
any outstanding WHEN-VALIDATE-RECORDs
pre-insert/update/delete (as appropriate)
post-insert/update/delete (as appropriate)

Suggest you look for code that references the item in question.
If nothing leaps out at you run the form in debug mode to see which trigger is doing it.
Re: 'COMMIT_FORM' TRIGGER [message #403115 is a reply to message #403006] Wed, 13 May 2009 15:46 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps there's no "code" that does the insert - COMMIT will save changes made in database items in any of form data blocks (which includes NULL values).
Previous Topic: Ensuring record uniqueness at block level
Next Topic: oracle management server problem
Goto Forum:

Current Time: Sun Aug 20 21:49:41 CDT 2017

Total time taken to generate the page: 0.00999 seconds