| How can I do this? [message #84048] |
Wed, 21 January 2004 12:32 |
mala
Messages: 18
Registered: March 2001
|
Junior Member |
|
|
I have a master-detail form. In the detail block, I have several records. Here is my name table (app_name).
ID Name_Type Name
1 old Mike
2 Current John
3 old Peter
4 old Andrew
I would like to create a button trigger which shall perform the following:
1) insert a record into database with a copy of current value. In the above case it will insert create a record for John as name_type = 'OLD'. So we have total of 5 records. Commit the transaction.
2) Scroll through my detail records (5) and go to one specific record and erase the values from it. In the above case, it should find John's record with name_type = 'Current' and erase John from it.
How can I accomplish this in Oracle forms using a button-pressed trigger?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
