Cut record from one table and Paste into another table

[sudam burkule]

I have a one problem that, Cut the record from One table and Paste that record into another table

Example :- i have two table Coll_name & Coll_name1
& i want to delete record from Coll_name table and to save that record into Coll_name1 table
So Please help me to how to do ?

[ck9663]

Try this. Make sure to use transaction processing to ensure consistency.

Happy Coding!!!


~~ CK

[NeoPa]

You need to execute the following basic steps :

1. BEGIN a transaction.
2. APPEND the single record (Use a filter) from [Coll_Name] into [Coll_Name1].
3. DELETE the single record (Use the same filter) from [Coll_Name].
4. If either step fails then ROLLBACK out of the transaction and report the failure.
5. Otherwise (Both steps succeeded.) COMMIT transaction.