Home » Developer & Programmer » Forms » Oracle 10g key combination to call form trigger (oracle DS10gR2)
icon8.gif  Oracle 10g key combination to call form trigger [message #430664] Wed, 11 November 2009 10:01 Go to next message
lanlani
Messages: 8
Registered: November 2009
Location: Beirut
Junior Member
Hi everyone,

I need to fire the KEY-DUPREC trigger as I click on the key combination Shift+P therefore; I added the following line of code in the frmweb.res file.

80 : 1 : "Shift+P" : 64 : "Duplicate Record"

It worked iff no error was raised. So, if I have a raise form trigger failure in the KEY-DUPREC trigger, a capital P will appear in the text field that called the trigger.

Can you please suggest a solution for preventing the capital P from appearing in the text field if a raise trigger failure existed in the KEY-DUPREC.

Thanks in advance

Lana
Re: Oracle 10g key combination to call form trigger [message #432553 is a reply to message #430664] Tue, 24 November 2009 22:27 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In the exception handler, before the 'raise', clear the field.

David
Re: Oracle 10g key combination to call form trigger [message #569830 is a reply to message #432553] Fri, 02 November 2012 05:37 Go to previous message
Mishaque
Messages: 2
Registered: March 2012
Location: Lahore
Junior Member
I don't know if there is a solution, but it sounds to me like a very bad idea to use Shift-P for duplicate_record. This means that you will never be able to input a capital letter P in any text field.
Previous Topic: how to count checked check boxes along with their checked and unchecked conditon
Next Topic: Read URL Header in forms
Goto Forum:
  


Current Time: Fri Aug 29 03:43:43 CDT 2014

Total time taken to generate the page: 0.12813 seconds