Undo the changed record!

[ching]

Hi

I have edit a record in my form (haven't been saved). Now, I want to undo the changes on my record. How can I do that?

Thanks

[tomate]

you need a button for undo or abort and under this button you lay a rollback. I hope that is about the simple question or you must say what you direct want.

[ching]

Hi

I have built a procedure to undo like this :
declare
lr_row varchar2(55);
begin
go_block(arameter.l_current_block);
lr_row := :m_form.rowid;
execute_query;
loop
exit when :m_form.rowid = lr_row;
exit when :system.last_record = 'TRUE';
next_record;
end loop;
end;

This procedure working fine, but when I changed the statment:
lr_row:= :m_form.rowid;
to
lr_row := rowidtochar(get_item_property(:system.current_block| |'.rowid', database_value));
this statement doesn't work.
The new statement has retur value ''.

I hope the new statement has ability to undo any current data block.