Temporary table in NAV
I recently found a very interesting blog post about temporary tables by Vjekoslav Babic. It explains really good the different ways a temporary table is handled when used as a parameter . You can basically call a method with a table by value or by reference. When you are using by value the data in the table is copied to a new variable and when you are using by reference you are actual using the same variable as the calling method. This work as expected when not using temporary tables. When it comes to temporary tables you may get an unexpected behavior when using the “by reference”.
Here is an example
The “ByRefereceWrong” will actual delete all records if you are passing a none temporary record to it. A fixed version with verification can be found in “ByRefence” where we use record reference and the ISTEMPORARY method.
Vjekoslav blog post found here does cover some other problem areas as “phantom insert”. I would recommend reading the complete post.
Error 1935 when installing Dynamics NAV 5.0 SP1
When I did try to install the NAV 5.0 SP1 client I run into an error 1935. This may happen on Vista and Windows 2008. Don’t know if Windows 7 also have this problem.
Error 1935; an error occurred during the installation of
assembly component {98CB24AD-52FB-DB5F-A01F-C8B3B9A1E18E}. HRESULT:0x800736CC.
The solution is simpler then it seems. You need to install Microsoft Visual C++ 20005 SP1 Redistributable pack. Remember if you are running on a 64 bit system you need to install both x86 and x64 package.