Thursday, 13 February 2014

jobs

1. How to copy object data to other object :
static void Job15(Args _args)
{
    Table2 a,b;
    a.CustAccount = "2014";
    a.Description = "hi";
    b =a;
    b.Description = "hello";
    info(strFmt("%1,%2",b.CustAccount,b.Description));

}
=====================================================================
static void jobjoinwherorderby(Args _args)
{
    InventSum inventsum;
    InventDim inventdim;
    InventLocation inventlocation;
    InventBatch inventbatch;
    int tot;
    while select * from inventsum
        join * from inventdim where inventsum.InventDimId == inventdim.inventDimId          
            join * from inventlocation where inventlocation.InventLocationId == inventdim.InventLocationId
                && inventlocation.InventLocationType == InventLocationType::Standard
                    join * from  inventbatch order by prodDate desc where inventdim.inventBatchId == inventbatch.inventBatchId                      
                 
    {
        tot++;
       
        //info(strFmt("%1,%2%3",inventsum.ItemId,inventsum.InventDimId,inventsum.PhysicalInvent));
    }
 info(strFmt("%1",tot));
}

No comments:

Post a Comment