Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

rollback deleted records

Former Member

‎11-30-2009 12:38 PM

0 Kudos

Hi Guys,

Can you please give me solution for the following issue.

I am deleting existing records from the database table. and adding new records to that same database table. After completion of deleting the records and add the new records to that data base table, user wants to get back the deleted records. So the deleted records will be add and new records will be deleted from the database table. Can you please give me solution for this process.

Thanks in advance,

Regards,

Sai

1 REPLY 1

former_member217544
Active Contributor

‎11-30-2009 12:43 PM

0 Kudos

Hi sai,

Before adding the new reocrds:

use a selet query to get the already existing records into an internal table. Now delete these reocrds from the database table and add the new records.

Now as the user wants to add the old deleted records, you can make use of the above internal table records which contains the initial deleted records.

Regards,

Swarna Munukoti

Edited by: Swarna Munukoti on Nov 30, 2009 1:44 PM