Re: FORMS 4.5: prevent Forms messages
Date: 1997/10/19
Message-ID: <19971019231201.TAA21395_at_ladder01.news.aol.com>#1/1
Hi Manfred
Yes, forms developers do know that constraints exist.
Check out the Oracle Utilities page on my web site (http://members.aol.com/jomarlen and you'll find an article on that very subject.
There are other ways, but the *secret* is to check whether delete is allowed before deleting the record in the form. It saves worrying about workarounds!
John
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com
e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/
The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.
>Subject: Re: FORMS 4.5: prevent Forms messages
>From: Derek Hardy <derekh_at_teknosys.co.uk>
>Date: Sun, Oct 19, 1997 15:45 EDT
>Message-id: <344A636A.10C71FEC_at_teknosys.co.uk>
>
>Use :SYSTEM.message_level, i.e.
>
>:SYSTEM.message_level := 5; -- Suppress Messages
COMMIT;
>: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