Re: Locking Problem

Ed,

To avoid displaying the acknowledgement, you can add to your code

Declare
  v_old_message_level varchar2(2);
Begin
  v_old_message_level := :system.message_level;   :system.message_level := '5';
 do_key('COMMIT_FORM');
  :system.message_level := v_old_message_level;   message('Your data was commited to the database.', no_acknowledge); End;

Ed Gillispie wrote in message <35294D58.2D9F_at_deere.com>...
>In Forms 4.5 our application is doing a DO_KEY("COMMIT_FORM"), when the
>user presses the commit. An acknowledgement box appears on the client
>workstation telling how many rows were commited and to press "OK" to
>continue. The problem is this, the tables that the user was inserting
>into are locked (until the user performs the acknowledgement), thus
>holding others up that want to use the same tables.
>
>Is there a way around this (ie no acknowledgement, forcing the message
>to the message line)?
>
>Ed Gillispie
>John Deere Insurance
>eg76440_at_deere.com
Received on Mon Apr 06 1998 - 00:00:00 CEST