Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Record (One Column sometimes inserted and sometime not) Dynamics ax 2012 x++

Posted on by Microsoft Employee

Hi Everyone,

I want to insert a record in a table , but the problem is one column value is sometime inserted and sometime not. the other two columns values are inserted correctly.

I debug the code values are retrieved correctly from Data Container but not inserted, and it does not shows or gives any insertion errors also tried with try/catch.

Thanks in Advance.

Here is my code.

where #colBankCode, #colBankName, and # colSwiftCode are integers 1,2,3 to retreive that column value from Data(Container)

    SWIFTCODES             swiftCodes;
    BankRegNum             value;
    ;

        ttsBegin;
        swiftCodes.initValue();
        value = conPeek(Data, #colBankCode);
        swiftCodes.RegistrationNumber  = value;
        swiftCodes.Name    = conPeek(Data, #colBankName);
        swiftCodes.SWIFTNo    = conPeek(Data, #colSwiftCode);
        swiftCodes.insert();
        ttsCommit;

*This post is locked for comments

  • Suggested answer
    kheir-eddine Profile Picture
    kheir-eddine 25 on at
    RE: Record (One Column sometimes inserted and sometime not) Dynamics ax 2012 x++

    Thank you AX 47,

    I fixed it by re-creating the table with all fields.

    I tried synchronization and restore, doesn't work, but removing caching not.

    Thanks !

  • kartikkp7 Profile Picture
    kartikkp7 365 on at
    RE: Record (One Column sometimes inserted and sometime not) Dynamics ax 2012 x++

    Try to synchronize and restore the table or removing cache memory..

  • kheir-eddine Profile Picture
    kheir-eddine 25 on at
    RE: Record (One Column sometimes inserted and sometime not) Dynamics ax 2012 x++

    Hi Shah_,

    Have you found what causes this. I have the same issue.

    Thanks,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Record (One Column sometimes inserted and sometime not) Dynamics ax 2012 x++

    swiftCodes.RegistrationNumber  = value;  //this column is sometimes inserted and sometimes not

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans