I think this is one of the most interesting sessions for developers.What is it about? Well, we always had the problem to get some info about the C/AL objects. We have some system tables to get some info like tables “Field”, “Key”, “Object”, but they give limited info on the object. To know more, we […]
Filed under: C/AL, DirectionsEMEA2010, NAVISION | Make a Comment »
Waldo already wrote a blogpost on this : http://dynamicsuser.net/blogs/waldo/archive/2010/05/21/directions-emea-2010-testing-your-functionality.aspx. But don’t worry, I’ll give some more info.
*agenda
-test features in NAV2009SP1 -test development?
-application test toolset for NAV. Build by Microsoft on top of test features.
*NAV2009SP1 test features
-target functional test through C/AL
-ensure no UI interaction is required
-classic vs RTC (test both)
-enable test of error handling
*Now codeunits have […]
Filed under: C/AL, DirectionsEMEA2010, NAVISION, RTC | Make a Comment »
Remember my function DosShell (http://www.mibuso.com/forum/viewtopic.php?t=12417)?
I created it to avoid the annoying popup in version 4.0 asking confirmation to run a program.
But I just found out that it can also be used to activate a program that is already active.
How to do it?
Very easy. You can play with the parameter “IintWindowStyle”. If you use value “1″, […]
Filed under: C/AL, NAVISION | Make a Comment »
How much times we have the question on the forum to downgrade a DB after someone accidently opened a DB with a newer NAV version and upgraded the DB?
Lot’s of times.
Downgrading is not so easy and it can be slow.
I needed to do it some time ago (luckily NOT for production but just for some […]
Filed under: C/AL, NAVISION, PERFORMANCE, SQL | Make a Comment »
Do you remember the Clustered Index bug of 4.0SP1 (see also http://www.mibuso.com/dlinfo.asp?FileID=594)?
In short: 4.0SP1 forgot to set the index-property “Clustered” on the primary key (the default is that the primary key is clustered). The result is that the tables were heap-tables and that is (generally) bad for performance.
The fix was to put the key-property Clustered […]
Filed under: C/AL, NAVISION, PERFORMANCE, SQL | Make a Comment »
I just got some strange error using STRSUBSTNO:
The text ‘…’ in STRSUBSTNO parameter no. 1 is too long.
Surprise : Is the string I give already longer than 1024 chars? But shouldn’t I have got an error when assigning that value to my variable that I sent into STRSUBSTNO?????
I was wondering if STRSUBSTNO was still limited […]
Filed under: C/AL, NAVISION | Make a Comment »
As we all (should) know, SQL is based on sets and NAV works iterative with records.
Sometimes it is possible to do set based programming also in NAV.
I just found an example in which we can speed up something thinking in sets (1 record is also a set!) instead of iterative. The beautiful thing is: it […]
Filed under: C/AL, NAVISION, NAVISION-DB, PERFORMANCE, SQL | 3 Comments »
Lately I have very little time to write blogs or to be online in general. But I found some time anyway to write a new how-to. Took me over a month anyway to write it.
I have noticed too many times that a lot of people use record-variables in a completely wrong way.
The smaller errors just […]
Filed under: C/AL, NAVISION, NAVISION-DB, PERFORMANCE, SQL | 1 Comment »
Create a new blog and join in the fun!