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