Undo the changed record!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Undo the changed record!

  1. #1
    Join Date
    Apr 2001
    Location
    indonesia
    Posts
    52
    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
    ching

  2. #2
    Join Date
    Mar 2001
    Posts
    188
    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.

  3. #3
    Join Date
    Apr 2001
    Location
    indonesia
    Posts
    52
    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.


    ching

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width