Using On-Error Trigger in Developer Forms

From: Tuns <tunde_oloniNOtuSPAM_at_yahoo.com.invalid>
Date: 2000/07/26
Message-ID: <12ea1f1c.95c5acbf_at_usw-ex0109-070.remarq.com>#1/1

[Quoted] Hi there!

I have a slight problem in trapping a constraint violation in forms runtime. I have altered the table to insert a unique constraint and in Forms Designer added an On_error trigger relating to the violation of this constraint when a user inserts non unique records. This works well when a user inserts a new record i.e the triggers returns a user friendly message but it does not when a user updates a record. The constraint is upheld but no message appears on the screen. Are there any FRM error codes that relate to updating a record that violates a unique constraint? Is this error code different from when inserting a new record that violates this constraint? Please help.

Thanks.
Tuns

Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Wed Jul 26 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: froek_at_my-deja.com: "How do I make a view with multiple "count" arguments"
Previous message: Jason Rigsbee: "Enterprise Manager Remove Database Problem"
Next in thread: kskasi_at_hotmail.com: "Re: Using On-Error Trigger in Developer Forms"
Reply: kskasi_at_hotmail.com: "Re: Using On-Error Trigger in Developer Forms"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message