OraFAQ Forum: Forms » Oracle 10g key combination to call form trigger

Home » Developer & Programmer » Forms » Oracle 10g key combination to call form trigger (oracle DS10gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 10g key combination to call form trigger [message #430664]

Wed, 11 November 2009 10:01

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

Report message to a moderator

Re: Oracle 10g key combination to call form trigger [message #432553 is a reply to message #430664]

Tue, 24 November 2009 22:27

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In the exception handler, before the 'raise', clear the field.

David

Report message to a moderator

Re: Oracle 10g key combination to call form trigger [message #569830 is a reply to message #432553]

Fri, 02 November 2012 05:37

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.

Report message to a moderator

Previous Topic:	forms cuts off spaces at the end of textfields.
Next Topic:	Read URL Header in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 06:14:28 CST 2025