Re: FORMS 4.5: prevent Forms messages

[Quoted] Use :SYSTEM.message_level, i.e.

:SYSTEM.message_level := 5; -- Suppress Messages  COMMIT;
[Quoted] :SYSTEM.message_level := 0; -- Enable Messages again

Manfred Tischendorf wrote:

> Hello FORMS Experts
>
> I have the problem, that I need to commit database insert very quickly.
> Therefore, I use the commit_form built in in the
> When-New-Record_instance Trigger. Now I have the problem, that sometimes
> the delete of a record is restricted by the constraints of the database.
> Therefore I wrote a workaround to requery the contents of the form,
> because the record is deletet from the form first and then the
> constraints are checked (DO ORACLE FORMS DEVELOPERS NOT KNOW, THAT
> THIS POSSIBLITY EXISTS, THAT TABLES CAN HAVE CONSTRAINTS!!!).
>
> Now I have succeeded with my workaround. But one last problem exists.
> Even when I have propagated the cvhanges with POST instead of COMMIT
> and then used a ROLLBACK when I got the error 40510 (record could not
> be deleted) I get a message when I requery the form:
>
> Forms
> Do you want to save the changes you have made?
> Yes No Cancel
>
> I tried a commit, it did not work, I did a rollback (I tried also
> without rollback) and I do not want to see this message.
> I "nulled" out the on-message-trigger. Without success.
>
> What can I do to build user-friendly masks in such a tool like FORMS ?
>
> Thanks for any suggestion.
>
> Manfred Tischendorf
Received on Sun Oct 19 1997 - 00:00:00 CEST