Home » Developer & Programmer » Forms » How to stop Auto Alert in Forms please?
How to stop Auto Alert in Forms please? [message #223174] Wed, 07 March 2007 20:40 Go to next message
Smith_X
Messages: 56
Registered: January 2007
Member
Hello,

In Form10g I notice that if my Pre-Insert (or any other trigger) do something with DDL SQL and then I use Forms_DDL('COMMIT') command. Forms will try to message me with error_code message#40405 'Nothing to Apply'.

But when I have more than one of those command in the same trigger, there are two or more error messages appear at the same time, Forms will push those message and appear as ALERT instead.

(Alert is a message box style that I need to click OK)

Well, it's pop-up a lot and I need to turn this feature off.

I try to use many many ways to track this error message but I cannot get rid it off by myself.

- On-Error trigger >> it's not gone T_T the ALERT still pop-up
- I try to set :SYSTEM.ERRORMESSAGE_LEVEL to 5 but the ALERT is still persist.

Please help me. This pop-up make my project look like full of bugs

Regards,
Smith_X
Re: How to stop Auto Alert in Forms please? [message #223198 is a reply to message #223174] Wed, 07 March 2007 23:57 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you use
STANDARD.COMMIT;
instead of
FORMS_DDL('COMMIT');
Re: How to stop Auto Alert in Forms please? [message #223419 is a reply to message #223198] Thu, 08 March 2007 17:06 Go to previous messageGo to next message
Smith_X
Messages: 56
Registered: January 2007
Member
Thank you very much for your reply, Littlefoot.

I use FORM_DDL('COMMIT') because I would like the trigger to update/insert data to other Table.

Example.

I update Receiving Document which Data Block connect to RECEIVE table. Then, when I create a document, I want a 'back screen' update to INVENTORY_MOVEMENT table, too.

So, I have a code to insert data into INVENTORY_MOVEMENT table. This code I post it in POST-INSERT trigger because I want to make sure the data that I want to insert is really exist in RECEIVE table.

But I had never been using standard.commit before. is it the same as COMMIT; please?
Re: How to stop Auto Alert in Forms please? [message #223458 is a reply to message #223419] Fri, 09 March 2007 00:23 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
STANDARD.COMMIT bypasses any checking and commits nonetheless you changed anything or not. I'm not *sure* it will help, but - won't cost a dime if you try it.
Re: How to stop Auto Alert in Forms please? [message #223468 is a reply to message #223458] Fri, 09 March 2007 00:51 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
An alternative could be to (temporarily) raise your message level (eg. to 25). Reset it after the commit.
Re: How to stop Auto Alert in Forms please? [message #224210 is a reply to message #223468] Tue, 13 March 2007 07:10 Go to previous messageGo to next message
alijeyan
Messages: 180
Registered: January 2007
Location: IRAN
Senior Member
HI

I use the Folowing :

:SYSTEM.ERRORMESSAGE_LEVEL :=20;

COMMIT;

:SYSTEM.ERRORMESSAGE_LEVEL :=5;


Try It ;

regards....
Re: How to stop Auto Alert in Forms please? [message #225449 is a reply to message #224210] Tue, 20 March 2007 00:01 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Use 'standard.commit'. The use of FORM_DDL('COMMIT') is an oxy-moron. ANY DDL by DEFINITION does a commit. Search this forum for 'standard.commit'.

David
Previous Topic: timestamp problem
Next Topic: Trigger KEY_EXIT error ORA-01400
Goto Forum:
  


Current Time: Fri Dec 09 17:33:18 CST 2016

Total time taken to generate the page: 0.62981 seconds