Hi
When i update
field on table, is calling this error on line code custInvoiceTrans.update(); Its problem with property update, but whe i need check and resolve this? Please, help.
public void initQuery()
{
........................
........................
while(queryRun.next())
{
queryRun.userUpdate(true);
custInvoiceTrans = queryRun.get(tableNum(CustInvoiceTrans));
try
{
salesLine = SalesLine::find(custInvoiceTrans.SalesId);
dboSalesAcrossOpsAndRes.InventSiteId = inventSiteId;
dboSalesAcrossOpsAndRes.CustAccount = custAccount;
//dboSalesAcrossOpsAndRes.JmgJobId = jobIdProcess;
//dboSalesAcrossOpsAndRes.RouteOprId = oprId;
dboSalesAcrossOpsAndRes.SalesId = custInvoiceTrans.SalesId;
dboSalesAcrossOpsAndRes.InvoiceId = custInvoiceTrans.InvoiceId;
dboSalesAcrossOpsAndRes.InvoiceDate = custInvoiceTrans.InvoiceDate;
dboSalesAcrossOpsAndRes.ItemId = custInvoiceTrans.ItemId;
dboSalesAcrossOpsAndRes.SalesOrderedQty = custInvoiceTrans.Qty;
dboSalesAcrossOpsAndRes.Weight = custInvoiceTrans.Weight; //salesLine.getGrossWeightPerItem();
dboSalesAcrossOpsAndRes.SalesLineAmount = salesLine.LineAmount;
dboSalesAcrossOpsAndRes.ValueByLine = salesLine.LineAmount *
custInvoiceTrans.Qty;
dboSalesAcrossOpsAndRes.ValueByWeight = dboSalesAcrossOpsAndRes.Weight *
dboSalesAcrossOpsAndRes.SalesOrderedQty;
dboSalesAcrossOpsAndRes.insert();
ttsBegin;
custInvoiceTrans.modifiedField(fieldNum(CustInvoiceTrans, DBOProcessed));
custInvoiceTrans.DBOProcessed = true;
custInvoiceTrans.update();
ttsCommit;
//open form DBOSalesAcrossOpsAndRes
args = new Args(formStr(DBO_SalesAcrossOpsAndRes));
formRun = classFactory.formRunClass(args);
formRun.init();
formRun.run();
formRun.detach();
}
*This post is locked for comments
I have the same question (0)
