Cut record from one table and Paste into another table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sudam burkule
    New Member
    • Oct 2012
    • 1

    Cut record from one table and Paste into another table

    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
    Recognized Expert Specialist
    • Jun 2007
    • 2878

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

    Happy Coding!!!


    ~~ CK

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32668

      #3
      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.

      Comment

      Working...