I have a customization that will travel through the lines of a sales order.
There could be two groups of SOLine records that I need to process on the same SO.
I have one main var to look at the SOLine records:
var lines = SelectFrom<SOLine>.
Where<SOLine.orderType.IsEqual<SOOrder.orderType.FromCurrent>
.And<SOLine.orderNbr.IsEqual<SOOrder.orderNbr.FromCurrent>>>.
View.Select(soOrderEntry);
Then I’m using:
foreach(SOLine line in lines)
{
//A bunch of code here
}
If I need another iterator to go through SOLine records on the same SO within the foreach loop and write (can I have multiple iterators on the same PXSelect?):
foreach(SOLine lineTwo in lines)
{
//A bunch of code here
}
If I update lineTwo with:
soOrderEntry.Transactions.Update(lineTwo);
Will that update the proper record or will having multiple variables confuse the cache?