| How to stop Auto Alert in Forms please? [message #223174] |
Wed, 07 March 2007 20:40  |
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 #223419 is a reply to message #223198] |
Thu, 08 March 2007 17:06  |
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?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
