• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1243
  • Last Modified:

How to make an Undo process in Oracle Forms 6i?

Hello!
I need to write an Undo option in a multiple data entry form. I want to apply this undo before commit changes, but only for the last single change I've made, for example, undo the last value I've typed or the last 3 check boxes I've clicked!
Is there any source example, or any idea?

Thank you in advance!
0
vfafou
Asked:
vfafou
  • 2
  • 2
1 Solution
 
jwahlCommented:
your question is not clear to me: "but only for the last single change" and "the last 3 check boxes I've clicked" - these are 3 actions ...?
why do you want to do a undo before commit? always? conditionally?
0
 
vfafouAuthor Commented:
OK! Suppose you have a data block with 8 text items (fields) repeated 15 times (rows). You can do data entry or modification within this block. So, you have done some changes and you realize you have accidentally changed a record or a specific cell. You don't have an undo operation available but you have done some changes to other records and you don't want to lose them! Is it possible to make an undo capability at least at row level?

Thank you for your reply!
0
 
vfafouAuthor Commented:
Oh! I forgot to tell you that after changes you may haven't press commit key... Or you may have? Is it possible to have the undo after commit?
0
 
jwahlCommented:
if you have 15 records á 8 text fields you can make changes in any order on every row in every field ... for a undo you have to record these changes and must do this with your own code, that gets very complex.

undo for the whole record is comperativly simpler: there is a forms built-in GET_ITEM_PROPERTY(item_name, DATABASE_VALUE), that returns the value that was originally fetched from the database.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now