Form overwrites previously entered information
lelandJul 16 2008 — edited Jul 24 2008Oracle Forms 9.2.0.4
I am editing a form that is used to input several inspections based off of one permit. The majority of the information is the same from entry to entry.
The problem I am having is the information is while the information is saving if there are multiple entries, only the latest entry is saved (or over written).
For example:
Record one is inputted and saved
Record one is copied to record two, modified and then saved.
There should be two records however record two will be the only one that shows up.
I have created a push button that will clear out the information that changes from permit to permit. Originally, I had a non-database data block copy certain variables and then clear out the form and copy them back but the information would not save at all.
What my question is, how do I "trick" the form to commit new entries as a separate row as opposed to over writing the previous entry? Or is there a better way to achieve what I am attempting to do?
Here is the SQL Statement from the push button that will be used:
newest code at last post
Any help would be appreciated. Thanks.
Message was edited by:
leland