Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Sunday, April 13, 2014

Job to copy all the record from one table to another in Dynamic AX

Hi,

// Copy data from one table to another using job
static void CopyData(Args _args)
{
    CustTable custTable ;
    DuplicateTable duplicateTable ;
    ;
    ttsBegin;
    while select custTable
    {
        buf2Buf(custTable ,duplicateTable );  
        duplicateTable.insert();
    }
    ttsCommit;
}

Regards,

No comments:

Post a Comment

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...