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

On Aug 8, 7:08 pm, papalph..._at_yahoo.com 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 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

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