public void insert2myTable(CustPackingSlipTrans _custPackingSlipTrans)
{
itemId itemId = _custPackingSlipTrans.ItemId;
packingSlipId packingSlipId = _custPackingSlipTrans.PackingSlipId;
InventTrans inventTrans;
InventTransOrigin InventTransOrigin;
container companies_con;
inventBatchId inventBatchId;
prodTable prodTable;
bomId bomId;
MyTable myTable;
companies_con = conins(companies_con, 1, curext());
if (itemId && InventTable::find(itemId).isFormulaOrBOMAllowed())
{
while select inventTrans group by inventTransOrigin, inventDimId, itemId, voucherPhysical
where inventTrans.VoucherPhysical == packingSlipId
join InventTransOrigin
where InventTransOrigin.recid == inventTrans.inventtransorigin
&& InventTransOrigin.InventTransId == _custPackingSlipTrans.InventTransId
{
inventBatchId = InventDim::find(inventTrans.InventDimId).inventBatchId;
select firstonly crosscompany: companies_con prodTable
where prodTable.ProdId == inventBatchId;
if(prodTable)
{
bomId = ProdTable.BOMId;
itemId = ProdTable.ItemId;
}
}
myTable.inventBatchId = inventBatchId;
myTable.InventTransId = _custPackingSlipTrans.InventTransId;
myTable.ItemId = itemId;
myTable.bomId = bomId;
myTable.insert();
}
}
/* DP class sample, with select query - processReport method */
/***/
MyTable myTable;
itemId itemId;
inventBatchId inventBatchId;
/***/
qr = new QueryRun(this.parmQuery());
query = this.parmQuery();
qbds = query.dataSourceTable(tableNum(BomTable));
qbr = qbds.findRange(fieldnum(BomTable, BOMId));
BOMId = qbr.value();
select firstonly myTable;
// I select any record from the table, unfortunately none was ever found, even though the insert() function was called earlier in the method
if(myTable)
{
InventBatchId = myTable.inventBatchId;
ItemId = myTable.ItemId;
}
/***/
