Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!w3g2000hsg.googlegroups.com!not-for-mail
From:  papalphaus@yahoo.com
Newsgroups: comp.databases.oracle.tools
Subject: FRM-40654: Record updated by another user error.
Date: Wed, 08 Aug 2007 10:08:45 -0700
Organization: http://groups.google.com
Lines: 13
Message-ID: <1186592925.381922.22610@w3g2000hsg.googlegroups.com>
NNTP-Posting-Host: 65.23.119.44
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1186592926 8084 127.0.0.1 (8 Aug 2007 17:08:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 8 Aug 2007 17:08:46 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 3.0.04506.30),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: w3g2000hsg.googlegroups.com; posting-host=65.23.119.44;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.tools:181354
X-Received-Date: Wed, 08 Aug 2007 13:08:46 EDT (text.usenetserver.com)

Is there a way to suppress the "FRM-40654 Record has been updated by
another user" error and automatically re-query when doing a save in
forms?  I have tried trapping the error in the on-error trigger and
adding an execute_query at the end of the key-commit trigger, but so
far not successful.  We are using:
Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
     With the Partitioning option
     JServer Release 9.2.0.7.0 - Production
Oracle Toolkit Version 10.1.2.0.2 (Production)
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production