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
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 !
Try to synchronize and restore the table or removing cache memory..
Hi Shah_,
Have you found what causes this. I have the same issue.
Thanks,
swiftCodes.RegistrationNumber = value; //this column is sometimes inserted and sometimes not
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156