if(!suppItemGroup)
{
suppItemGroup.clear();
suppItemGroup.GroupId = inventTableModule.SuppItemGroupId;
suppItemGroup.Module = ModuleInventCustVend::Invent;
suppItemGroup.insert();
}
select ItemId,ModuleType,SuppItemGroupId
from inventTableModuleloc
where inventTableModuleloc.ItemId == inventTableModule.ItemId
&& inventTableModuleloc.ModuleType == ModuleInventPurchSales::Sales;
inventTableModuleloc.clear();
inventTableModuleloc.SuppItemGroupId = inventTableModule.SuppItemGroupId;
inventTableModuleloc.ModuleType = ModuleInventPurchSales::Sales;
inventTableModuleloc.insert();
select ItemId,ModuleType,SuppItemGroupId
from inventTableModuleloc
where inventTableModuleloc.ItemId == inventTableModule.ItemId
&& inventTableModuleloc.ModuleType == ModuleInventPurchSales::Purch;
inventTableModuleloc.clear();
inventTableModuleloc.SuppItemGroupId = inventTableModule.SuppItemGroupId;
inventTableModuleloc.ModuleType = ModuleInventPurchSales::Purch;
inventTableModuleloc.insert();
if we see the above code we are using a single table buffer which we are clearing and re inserting it is better than creating a new buffer and using it.
{
suppItemGroup.clear();
suppItemGroup.GroupId = inventTableModule.SuppItemGroupId;
suppItemGroup.Module = ModuleInventCustVend::Invent;
suppItemGroup.insert();
}
select ItemId,ModuleType,SuppItemGroupId
from inventTableModuleloc
where inventTableModuleloc.ItemId == inventTableModule.ItemId
&& inventTableModuleloc.ModuleType == ModuleInventPurchSales::Sales;
inventTableModuleloc.clear();
inventTableModuleloc.SuppItemGroupId = inventTableModule.SuppItemGroupId;
inventTableModuleloc.ModuleType = ModuleInventPurchSales::Sales;
inventTableModuleloc.insert();
select ItemId,ModuleType,SuppItemGroupId
from inventTableModuleloc
where inventTableModuleloc.ItemId == inventTableModule.ItemId
&& inventTableModuleloc.ModuleType == ModuleInventPurchSales::Purch;
inventTableModuleloc.clear();
inventTableModuleloc.SuppItemGroupId = inventTableModule.SuppItemGroupId;
inventTableModuleloc.ModuleType = ModuleInventPurchSales::Purch;
inventTableModuleloc.insert();
if we see the above code we are using a single table buffer which we are clearing and re inserting it is better than creating a new buffer and using it.
No comments:
Post a Comment