Re: FRM-40654: Record updated by another user error.
Date: Thu, 09 Aug 2007 10:27:50 +0200
-----BEGIN PGP SIGNED MESSAGE-----
> 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 126.96.36.199.0 - Production
> With the Partitioning option
> JServer Release 188.8.131.52.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
Define "not successful" - other errors? If so which? If none - what behavior do you witness?
Did you change the message level to suppress the error?
In general, I would not want to suppress this error by
simply re-querying; I'd at least have the opportunity
to jot down what I'd entered so far.
Frank van Bortel
Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
-----END PGP SIGNATURE----- Received on Thu Aug 09 2007 - 10:27:50 CEST