Tuesday, March 8, 2016

Update_record set

This method is used to update the records in table........(and copies the record from one field to another with in a table)

static void update_recordset(Args _args)
{
    inventtrans inventtrans;

    ttsBegin;

    update_recordset inventtrans
    setting InventTransaction = inventtrans.Qty
    where inventtrans.transtype == inventtranstype::InventTransaction;


    update_recordset inventtrans
    setting TransferOrderReceive = inventtrans.Qty
    where inventtrans.transtype == inventtranstype::TransferOrderReceive;

     update_recordset inventtrans
    setting purch = inventtrans.Qty
    where inventtrans.transtype == inventtranstype::purch;


    update_recordset inventtrans
    setting InventCounting = inventtrans.Qty
    where inventtrans.transtype == inventtranstype::InventCounting;


     update_recordset inventtrans
    setting sales = inventtrans.qty
    where inventtrans.transtype == inventtranstype::sales;

    update_recordset inventtrans
    setting TransferOrderShip = inventtrans.Qty
    where inventtrans.transtype == inventtranstype::TransferOrderShip;

     ttsCommit;


}

No comments:

Post a Comment