Can't update Purchline and PurchTable

(0) Share

Report

Posted on by Vladislav

159

Hi everyone,

I want to update two fields in Purchline and when I debbugting the code i go in UPDATE method but it doesn't execute to the end and ExecuteByLine go to catch and nothing happnes.

public void ExecuteByLine()

{
    try
    {
        while select firstOnly forUpdate _purchLine
            where _purchLine.dataAreaId == _areaId
                  && _purchLine.PurchId == _purchId
                  && _purchLine.InventTransId == inventTransId
        {
            _purchLine.InterCompanyOrigin = 0;
            _purchLine.InterCompanyInventTransId = "";
            _purchLine.update();
        }

    }
    catch
    {
        error(strFmt("Error! The operation is unsuccessful!"));
    }
}

When I try to update PurchTable , the ExecuteByHeader doesn't go to catch mathed and everything looks fine but when I check what happened in SQL . The result is nothing.

public void ExecuteByHeader()
{
    try
    {
        while select forUpdate _purchTable
            where _purchTable.dataAreaId == _areaId
                  && _purchTable.PurchId == _purchId
        {
            ttsBegin;
            _purchLine.clear();
            _purchTable.InterCompanyOrigin = 0;
            _purchTable.InterCompanyCompanyId = "";
            _purchTable.InterCompanySalesId = "";
            _purchTable.InterCompanyOrder = 0;
            _purchTable.update();
            ttsCommit;
        }
    }
    catch
    {
        error(strFmt("Error! The operation is unsuccessful!"));
    }
}

Sometimes in debug mode throws this error:

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Martin Dráb 239,069 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Which line is throwing the error? Which kind of exception it is?

Was this reply helpful? Yes No
Vladislav 159 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut ,

my idea is to execute one of them according on the circumstances. I tried with ttsbegin and ttscommit , but nothing happend

Thank you.

Was this reply helpful? Yes No
Vladislav 159 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin Drab,

By debbuging get to line with _purchLine.update(); and I mean this method doesn't execute it at all and after that go to catch. First throw my error and after that display this error from picture in debug tools -> Infolg . Also throw and this exception:

Regards,

Vladislav

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,069 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
You're missing the transaction. While select with firstOnly makes little sense. You have a filter for dataAreaId but AX will always filter by the current company anyway (either remove it, use crossCompany or changeCompany()). InventTransId uniquely identifies the line, therefore the filter on PurchId shouldn't be needed. Your code swallows the exception (which may be your intention as well as a bug). strFmt() without any placeholder to replace is useless and can be thrown away.

Try this:

public void ExecuteByLine() { PurchLine purchLine; try { ttsBegin; select firstOnly forUpdate purchLine where purchLine.InventTransId == inventTransId if (purchLine) { purchLine.InterCompanyOrigin = 0; purchLine.InterCompanyInventTransId = ""; purchLine.update(); } ttsCommit; } catch { throw error("Error! The operation is unsuccessful!"); } }

Note that you could also use update_recordset instead of fetching the record and sending it back to database.

Was this reply helpful? Yes No
Vladislav 159 on at

Like (0)

Report
Copy link

Link copied!

Martin Drab ,

the problem was ttsBegin and ttsCommit.I didn't put them on the right place.

Thank you a lot of !

And also one small question. I have form for this class, who I create only with class and how to attach here :

Was this reply helpful? Yes No
Martin Dráb 239,069 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Please create a new thread for the new question not related to "Can't update Purchline and PurchTable" and explain it in detail there.

Was this reply helpful? Yes No