Home » Developer & Programmer » Forms » when-remove-record
when-remove-record [message #204405] Mon, 20 November 2006 09:17 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: when-remove-record [message #204538 is a reply to message #204424] Tue, 21 November 2006 03:25 Go to previous messageGo to next message
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?.
Re: when-remove-record [message #204574 is a reply to message #204538] Tue, 21 November 2006 05:31 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: when-remove-record [message #205127 is a reply to message #204574] Thu, 23 November 2006 07:06 Go to previous message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
Did in key-Delrec trigger.
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:
  


Current Time: Sun Dec 04 14:58:09 CST 2016

Total time taken to generate the page: 0.06911 seconds