i have put a pxTransaction in the release button in the invoices screen .
its working but it sometimes gets deadlocked by another process
This is the code that i think makes the problem
using (PXTransactionScope ts = new PXTransactionScope())
{
PXDatabase.Update<MixPayments>(new PXDataFieldAssign<MixPayments.docType>(inv.DocType),
new PXDataFieldAssign<MixPayments.refNbr>(inv.RefNbr),
new PXDataFieldRestrict<MixPayments.orderNbr>(mix.OrderNbr),
new PXDataFieldRestrict<MixPayments.orderType>(mix.OrderType));
ts.Complete();
}
is there a way to use with nolock in acumatica like SQL ?
or is there another way to make this code work ?
Best answer by vardan22
View original