OraFAQ Forum: Forms » How is "KEY-DUP-ITEM" trigger work?

Home » Developer & Programmer » Forms » How is "KEY-DUP-ITEM" trigger work? (Appl 11.5.10.2 Linux X86)

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

How is "KEY-DUP-ITEM" trigger work? [message #289703]

Tue, 25 December 2007 11:49

msuphaluk
Messages: 20
Registered: December 2007
Location: BKK,Thailand

Junior Member

Dear All,
I am facing the p/b about the "KEY-DUP-ITEM" trigger because I can not reference to the previous value.

My objective is when user creates a new record and presses "Shift + F5" on field "A". The program should copy/place the previous value of field "A" to field "A" and also copy/place previous value of field "B" to field "B".

My form is registered under Oracle Application 11.5.10.2 Linux X86.

Thank you for your kindly advices.

Suphauk M.

Merry Christmas and Happy New Year 2008.

Report message to a moderator

Re: How is "KEY-DUP-ITEM" trigger work? [message #289704 is a reply to message #289703]

Tue, 25 December 2007 12:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

I can not reference to the previous value.

Why not?

An item value is duplicated by using the DUPLICATE_ITEM built-in, which assigns the current item the same value as the instance of this item in the previous record.

Did you code the KEY-DUP-ITEM trigger? If so, how does it look like? What does a combination of <Shift + F5> do on your system?

Report message to a moderator

Re: How is "KEY-DUP-ITEM" trigger work? [message #289746 is a reply to message #289704]

Wed, 26 December 2007 00:24

msuphaluk
Messages: 20
Registered: December 2007
Location: BKK,Thailand

Junior Member

Dear Littlefoot,
My problem was resolved already. I have placed the code "DUPLICATE_ITEM" like your suggestion.

Thank you very much for your kindly.

Suphaluk M.
BKK, Thailand.

Merry Chirstmas and Happy New Year 2008.

Report message to a moderator

Previous Topic:	Setting Attributes of a cell in Table Display
Next Topic:	Print Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 03:45:26 CST 2025