Home » Developer & Programmer » Forms » Not to clear the record after delete
Not to clear the record after delete [message #414374] Tue, 21 July 2009 21:14 Go to next message
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
Member
Hello,

Employee table consists of employee number and name columns.

Select, insert and update grant is given for this table. No delete grant. (Backend level).

When I try to delete the employee "GGGG", it pops up the message as shown (refer attachment), because a code is written in ON-ERROR trigger
DECLARE
err_code NUMBER := ERROR_CODE;
err_txt VARCHAR(110);
BEGIN
IF err_code = 40510 THEN
err_txt := 'You don''t have the privilege to delete this record.';
Message(err_txt);
Message(err_txt);
END IF;
END;

The record is cleared; you can see the employee "GGGG" is not shown (refer attachment), but when I query again it shows the employee "GGGG".

My Query:
The record should not to clear; the cursor should go back the employee "GGGG", after populating the message. How to do it?

Thanks.

-Karthik
Re: Not to clear the record after delete [message #414409 is a reply to message #414374] Wed, 22 July 2009 01:02 Go to previous messageGo to next message
tarekfathi2003
Messages: 23
Registered: August 2008
Location: kw
Junior Member
Where is the attachement??
Re: Not to clear the record after delete [message #414417 is a reply to message #414374] Wed, 22 July 2009 01:37 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Who owns this table?
Who runs the form (and deletes the record)?
Previous Topic: How to show same text item value from one form to another form
Next Topic: How to update records in second window/blocks from base blocks
Goto Forum:
  


Current Time: Sun Dec 04 06:12:26 CST 2016

Total time taken to generate the page: 0.17233 seconds