Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Record (One Column som...

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

(0) Share

Report

Posted on by Community Member 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

All responses (4)

Answers (0)

Suggested answer

kheir-eddine 25 on at

Like (0)

Report

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 365 on at

Like (1)

Report

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 25 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

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