Re: Commit Automatically from a Form

From: Challe <challe_at_carus.fi>
Date: Sun, 16 Jan 2000 14:26:45 +0200
Message-ID: <85sdhb$600$1_at_gandalf.alcom.aland.fi>


Hi!

Create a program unit called 'autosave' like:

procedure autosave
is
begin

     default_value( 1, 'global.autosave_on' );
     if :system.form_status = 'CHANGED' then
        if :global.autosave_on = 1 then
           :global.autosave_on = 0;
            commit_form;
           if :system.form_status <> 'QUERY' then
              -- Your error handling
           end if;
     end if;
     end if;

   :global.autosave_on := 1;
end;

Then put
  autosave;
in a form level WHEN-NEW-RECORD-INSTANCE trigger.

/Charles Received on Sun Jan 16 2000 - 13:26:45 CET

Original text of this message