| Unable to Delete record! [message #79270] |
Mon, 20 May 2002 21:54  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
