OraFAQ Forum: Forms » 'COMMIT

Home » Developer & Programmer » Forms » 'COMMIT_FORM' TRIGGER (OS:LINUX.)

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

'COMMIT_FORM' TRIGGER [message #403006]

Wed, 13 May 2009 07:44

euser
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

Report message to a moderator

Re: 'COMMIT_FORM' TRIGGER [message #403013 is a reply to message #403006]

Wed, 13 May 2009 08:13

cookiemonster
Messages: 13972
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.

Report message to a moderator

Re: 'COMMIT_FORM' TRIGGER [message #403115 is a reply to message #403006]

Wed, 13 May 2009 15:46

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

Report message to a moderator

Previous Topic:	FRM-41213 In AIX 5
Next Topic:	How to change form builder color..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 21 23:46:08 CDT 2025