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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
kheir-eddine 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Shah_,

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

Thanks,

Was this reply helpful? Yes No
kartikkp7 365 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

kheir-eddine 25 on at

Like (0)

Report
Copy link

Link copied!

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 !

Was this reply helpful? Yes No