Re: Form 5.0 Triggers

From: Patrick Wolf <patrick.wolf_at_telekabel.at>
Date: 1998/02/28
Message-ID: <34f894ef.515110_at_news.telekabel.at>#1/1

On Fri, 27 Feb 1998 10:30:57 -0500, Frank W Phillips JR <FWP_at_vpha.ufl.edu> wrote:

>Based on a user request I am attempting to write a trigger that will
>commit a form record to the database after the last field is completed.
>The problem, I can not find a trigger that will allow this.
>Do_key(‘commit_form’) is a restricted procedure. When-Validate-Item and
>Post-Text-Item triggers only allow unrestricted procedures.

Hi,

try the When-New-Item-Instance trigger defined on block level.

example code:

begin

    if all_fields_are_entered (or check for last field

                with :SYSTEM.CURSOR_ITEM)
    then
        ask_user;
        if edit then
           ...
        elsif ...
        end if;
        commit;
        create_record;

    end if;
end;

Hope this helps
Patrick

---

Patrick Wolf
Working for Scientific Games, Vienna

E-Mails: patrick.wolf_at_telekabel.at (private)

         wolf_at_scigames.at (firm) Received on Sat Feb 28 1998 - 00:00:00 CET