OraFAQ Forum: Forms » when-remove-record

Home » Developer & Programmer » Forms » when-remove-record

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

when-remove-record [message #204405]

Mon, 20 November 2006 09:17

yogen
Messages: 39
Registered: October 2006
Location: UK

Member

Hi All,

I am working on forms 6i.
My requirement is that when user remeoves a record he must get a alert saying does he wants to commit the changes or rollback.

if presses yes record must be deleted from database forever otherwise that record must stay in the datablock as well as database.this i could think of doing by queriyng the form again after user's response to the alert.
i am trying to use when-remove-record for this problem and able to successfully display the alert also but since i can't use restricted built-ins in this trigger i don't know how to query the form automatically again or how to commit the removed records in case user had pressed yes.

please help me meeting this requirement .

thanks in advance.

[Updated on: Mon, 20 November 2006 10:23]

Report message to a moderator

Re: when-remove-record [message #204424 is a reply to message #204405]

Mon, 20 November 2006 10:56

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

Senior Member
Account Moderator

Alert the user BEFORE deleting the record, not when you've already done that. Doing so, there won't be need to query anything, rollback or whatever - the record will simply stay where it was.

Report message to a moderator

Re: when-remove-record [message #204538 is a reply to message #204424]

Tue, 21 November 2006 03:25

yogen
Messages: 39
Registered: October 2006
Location: UK

Member

Thanks for the reply but in which trigger i can do that.please tell me that also?.

Report message to a moderator

Re: when-remove-record [message #204574 is a reply to message #204538]

Tue, 21 November 2006 05:31

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

Senior Member
Account Moderator

In your opinion, which triggers would be candidates? Which ones are used when you want to delete a record? Do a little research (i.e. test it by yourself) and you'll probably find the solution.

Report message to a moderator

Re: when-remove-record [message #205127 is a reply to message #204574]

Thu, 23 November 2006 07:06

yogen
Messages: 39
Registered: October 2006
Location: UK

Member

Did in key-Delrec trigger.

Report message to a moderator

Previous Topic:	FRM-10142 The HTTP Listener is not running on server. Please start the listener or check your run ti
Next Topic:	Key-Next_Item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 06:52:21 CST 2025