Kriki’s Dynamics NAV blog

I already blogged about the book I was going to read.
I haven’t finished the book yet, but I didn’t want to wait to write a review. Finishing the book will take me some more weeks because I am not reading it full time (lack of time) but I read it on my smartphone whenever I […]

Filed under: C/AL, Dynamics, NAV, NAV2013, RTC | Make a Comment »

I finished reading "Implementing Microsoft Dynamics NAV 2013" about which I wrote in another post.
I took me a little longer than expected. Not because it so difficult to read but because of some private I have been very busy lately (both privately as for work).
As a rule, technical books have the habit of being a […]

Filed under: C/AL, Dynamics, NAV, NAV2013, RTC, WebService | Make a Comment »

Question 1:
What happens if you compile these 3 commands and you are using the servicetier?
Object.”BLOB Reference”.EXPORT(‘c:\xx\y.txt’);
Object.”BLOB Reference”.EXPORT(‘c:\xx\y.txt’,FALSE);
Object.”BLOB Reference”.EXPORT(‘c:\xx\y.txt’,TRUE);
Answer 1:
You get this warning twice: “Function ‘EXPORT’ is obsolete for Microsoft Dynamics NAV Server.”
Question 2 (Surprised): Twice? Why not three times?
Answer 2: The first line (without the second parameter) does NOT generate the warning! And when running […]

Filed under: C/AL, Dynamics, NAV, NAV2013, RTC, WebService | Make a Comment »

And another book that is on my (e-)shelf : "Programming Microsoft Dynamics NAV 2013" (http://www.packtpub.com/programming-microsoft-dynamics-nav-2013/book).

I am not starting it immediately, but after "Implementing Microsoft Dynamics NAV 2013", I will be "Programming Microsoft Dynamics NAV 2013"!

Filed under: C/AL, NAV, NAV2013 | Make a Comment »

Today I had a problem with a table that has around 5 million records. The table has as primary key “Header No.”,”Transaction No.”.
In the table is a field “Order No.” that at the moment is blank for all records.
I also had an index on that field, because I will need to search for it. I […]

Filed under: C/AL, NAV, PERFORMANCE, SQL, Uncategorized | 2 Comments »

I just read this post: http://mibuso.com/blogs/zenandtheartofcsidedevelopment/2013/02/22/consuming-nav-web-services-using-powershell/.
And I wondered if it was so easy as is looked. So I tried it out and indeed: It was so easy.
Now, I need something a little more complicated: I want to be able to send a parameter (I only need 1!) into the function. And I want to put […]

Filed under: C/AL, NAV, Powershell, SQL, WebService | 3 Comments »

No, they don’t exist. You can’t use them, but I got these:

This error is quite clear: you are using FORM.RUNMODAL somewhere and that is not allowed.

But this error is less clear: It means you are using FORM::"Some Form" somewhere.
The fun part is that if you have the object open and hit F11 to compile and […]

Filed under: C/AL, NAV, NAV2013 | Make a Comment »

RESET;
IF FINDSET THEN
REPEAT
MESSAGE(’A:%1′,Code);
UNTIL NEXT(-1) = 0;
RESET;
ASCENDING(FALSE);
IF FINDSET THEN
REPEAT
MESSAGE(’B:%1′,Code);
UNTIL NEXT(-1) = 0;
RESET;
IF FINDSET THEN
REPEAT
MESSAGE(’C:%1′,Code);
UNTIL NEXT = 0;
Question: which of these 3 IF-THEN-REPEAT-UNTIL will give all records? Which generates an error? Which gives only 1 record?
A: gives only 1 record
B: gives the all data and no error
C: gives the all data and no error
Seen something weird? Did […]

Filed under: C/AL, NAV, NAV2013 | Make a Comment »

I was testing a XML-port used as a parameter in a function of a codeunit that was published as a webservice (I hope this is clear!).
Let me rephrase it anyway:
I have a codeunit published as a webservice. In that codeunit I have a function and that function has a XML-port as parameter.
So when I put […]

Filed under: C/AL, NAV, NAV2013, WebService | 2 Comments »

If you have a recordreference and want to use the value of a field in the recordreference, you can use it in this way:
 
TheRecordReference.FIELD(10).VALUE
 
You might even do something as this
 
SomeFieldReference.SETRANGE(TheRecordReference.FIELD(10).VALUE);
 
BUT for some reason, it can happen this crashes the NAV client. I had the problem with 50SP1  Build 30488 (I don’t know about more recent […]

Filed under: C/AL, NAV | 1 Comment »