delete_record not removing record from screen
638062May 13 2010 — edited May 17 2010Hi I am trying to select a row on the screen and delete a individual row from the screen after hitting the delete button. Whenever i select the row it gets highlighted and also the alert box comes up asking if the record needs to be deleted. When I say yes I notice that the row does not get deleted. The code behind the delete button is as follows
(P.S the block is based of a table and commit_form works and changes are saved to db but not delete_record)
begin
--
Set_Item_Property('my_block.emp_no_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.emp_LName_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.emp_FName_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.last_worked_date_copy',current_record_attribute,'va_delete_record');
--
synchronize;
Set_Alert_Property(alert_id, ALERT_MESSAGE_TEXT, 'Do you want to delete the Highlighted record? {NOT YET}');
alert_button := Show_Alert(alert_id);
IF alert_button=alert_button1 THEN
delete_record;
msg_info('The record has been successfully deleted');
END IF;
--
Set_Item_Property('my_block.emp_no_copy',current_record_attribute,'va_focus_record');
Set_Item_Property('my_block.emp_LName_copy',current_record_attribute,'va_focus_record');
Set_Item_Property('my_block.emp_FName_Copy',current_record_attribute,'va_focus_record');
Set_Item_Property('my_block.last_worked_date_copy',current_record_attribute,'va_delete_record');
--
--
end;