If you did not went through the previous post on “Understanding COMMIT and Transaction Scope within Microsoft Dynamics NAV“, I suggest you to go through it before start reading this blog post.
What do you think about temporary records and transaction scopes?
Most of developers think temporary records are managed as transactions, but it’s not.
Even if you call COMMIT within the code, it does not respect the effect of it. Also if error occurred during the process then, system will not rollback the changes. Any change made to temporary table will have to roll back manually (should handle through code).
It is simple. Just keep in mind that use of temporary tables makes life easy, also it can worse things too if you do not handle them with care.
Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara