Home » Developer & Programmer » Forms » Unable to Delete record!
Unable to Delete record! [message #79270] Mon, 20 May 2002 21:54 Go to next message
payal
Messages: 6
Registered: February 2002
Junior Member
Hi everybody...
I cannot delete any record from my data block

In the form I chose the record to delete thru a LOV and then click on the delete button which has the following code in its when-button-pressed trigger

begin

go_block ('shape');

delete_record;

commit_form;

end;

I get FRM-40401: no changes to save, even though I am giving the commit_form statement...
Is there any other way to delete a record?

Thanx
Payal
Re: Unable to Delete record! [message #79271 is a reply to message #79270] Mon, 20 May 2002 22:05 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
hiii
u r selecting values from lov into items and deleting that record from the block, so there is no change for the block an now if u say commit it'll say 'no changes to save'.

what u can do is once u select a record from LOV try to say execute query on a particular condition ( for exmaple u r selecting a record of employee no 100, so set the default where condition of the block to empno = 100 and ssy execute_query) and then write the same code u've written... now it'll delete the record from the table...

hope i've understood ur problem and given u a solution...

cheers
ram
Previous Topic: Urgently!!! set_block_property to clear query_data_block_name
Next Topic: Re: problems while inserting a new record
Goto Forum:
  


Current Time: Mon Aug 03 05:09:41 CDT 2020