One of the things I spend a lot of time on during my workshop is design for performance and using temporary tables. There are so many great things you can do here.
Let’s look at this code:
Typically after an insert you would expect this error when trying a RUNMODAL
But, not in this case. Here we have this:
The reason why this works is the use of a temporary table. The record is not actually inserted into the SQL Server database.
This is very useful for example when running a wizard. This allows you to roll back the transaction very easily when the wizard was cancelled.
Do you want to lean more?
During my workshop I spend a lot of time on these typical things in NAV that are poorly documented but very powerful.
The next workshop is in Copenhagen, close to the heart of NAV developement.
Register here. (QBS Partners can use vouchers)