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));
}
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