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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

papalphaus_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
>
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.
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGutAGLw8L4IAs830RAnUSAJ0Z5Y39MY5HgTPJg2e54U3+mxigWgCfeqRp 3eQDfyAv2S6QP+jo7HwGf18=
=RsbL
-----END PGP SIGNATURE----- Received on Thu Aug 09 2007 - 10:27:50 CEST