Re: FRM-40654: Record updated by another user error.

From: F van Nimwegen <>
Date: Thu, 09 Aug 2007 09:56:53 -0000
Message-ID: <>

On Aug 8, 7:08 pm, wrote:
> 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 (Production)
> Oracle9i Enterprise Edition Release - Production
> With the Partitioning option
> JServer Release - Production
> Oracle Toolkit Version (Production)
> PL/SQL Version (Production)
> Oracle Procedure Builder V10. - Production

What is the reason of the FRM-40654 error? When someone else has changed the record then you should get a warning and requery, when your commit process modifies some columns in the block at the serverside yoy can requery after a commit or use the block properties "DML Returning Value" and "Update Changed Columns Only".

This properties can be used from forms 6i and a 8i database to avoid a requery when some of the columns in your block are changed by database triggers during the commit proces. Received on Thu Aug 09 2007 - 11:56:53 CEST

Original text of this message