Home » Developer & Programmer » Forms » Capture Delete_record
Capture Delete_record [message #381651] Mon, 19 January 2009 02:27 Go to next message
mylraj
Messages: 16
Registered: January 2009
Location: Manama
Junior Member
Hi,


user clicks Delete button, i am calling the Delete_Record from this button . after the delete_record, the record is not available on the block,How can i capture the Deleted Record ?

basically i want to capture the deleted record for audit purpose. i am interested in using the screen level audit rather then the table level

REgards

[Updated on: Mon, 19 January 2009 11:29]

Report message to a moderator

Re: Capture Delete_record [message #381800 is a reply to message #381651] Mon, 19 January 2009 23:20 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In the 'pre-delete' trigger at the block level write your own code to insert the record details, plus audit information into a 'deleted_record' table.

David
Re: Capture Delete_record [message #381806 is a reply to message #381651] Mon, 19 January 2009 23:57 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
write a on_delete trigger on block as


insert into audit_table(empid)
values (:emp.empno);

delete_record;


Does it solve your problem?
Re: Capture Delete_record [message #382095 is a reply to message #381800] Tue, 20 January 2009 23:27 Go to previous message
mylraj
Messages: 16
Registered: January 2009
Location: Manama
Junior Member
Hi David,

It is working, thanks

Mylraj
Previous Topic: populating record in multi recor d block
Next Topic: Add_List_Element
Goto Forum:
  


Current Time: Sat Dec 10 14:40:30 CST 2016

Total time taken to generate the page: 0.23695 seconds