Waldo's Blog
Microsoft Dynamics NAV

Recent Posts

Tags

Community

Email Notifications

Other Blogs

Communities

Archives

Posted: by
Bookmark and Share

Comments

Erik P. Ernst said:

Hi Eric,

It's good to have you here. I'm looking forward to a lot of interesting blog entries from you....

# April 23, 2007 7:07 AM

David Singleton said:

Hey Eric, great to see you have started blogging. If you need any help about how to administer the CS blogs, just let us know.

# April 23, 2007 7:11 AM

David Singleton said:

Hey great post. This Araxis looks great.

# May 3, 2007 4:13 PM

gregory said:

I use the developers toolkit for the same task. I compare the objects of a client database with the standard one that comes with the clients version.

# May 4, 2007 1:46 AM

Erik P. Ernst said:

I've been using Araxis for 5 years now and it's a great tool.  But I can see I'm not such a heavy user as you. In general I always use Per Mogensen's MergeTool for a full merge and compare in connection with upgrades. It's using a three tier model, where you have the old base, the new base and the modified version of the customer. It's basically the same model as the NAV Developers Toolkit, but that's not so strange, as they simply copied his mergetool (he developed it when he used to work for Navision) and used it as the base for the Developers Toolkit. They even copied the errors that used to be in the Mergetool! But what I like with the Mergetool is that it's giving you the semi-automatic merge, where it's basically merging most of your objects automatically, and you only have to deal about the ones with bigger conflicts.

Araxis I usually use if I only have a few objects I need to compare, and with the three column view you can actually still do some nice manual merges.

# May 4, 2007 2:47 AM

Marq said:

Hey Waldo, are you a NAV MVP or an Axarix MVP?

Great post!

# May 4, 2007 5:18 AM

DenSter said:

I like the drilldown, I might just give Araxis a try. Can I buy shares somewhere first though?

# May 4, 2007 9:54 AM

Erik P. Ernst said:

I don't think you can by shares now:

"Araxis Ltd is based in the Isle of Man, British Isles, and is a privately held company. Araxis is entirely self-funding and self-sustaining"...

But if one could, I think I would have bought some a few years ago!

# May 8, 2007 5:38 AM

waldo said:

I agree with Erik.

For big merges, I use dev toolkit or mergetool ... for merging a few objects or comparing databases (where this blogpost was about), I always use araxis.

And indeed, you should be able to buy shares of Araxis ;)

# May 9, 2007 12:41 AM

David Singleton said:

Since I don't normally do the actual work of merging, Smile but just need to see what has been done before and after, I think for me this Araxis look ideal.

# May 9, 2007 2:59 AM

Erik P. Ernst said:

Good! Even for long term NAV consultants, this spreadsheet is a must for trouble shooting permission problems.

# May 28, 2007 12:16 PM

Erik P. Ernst said:

Very good...  Especially the part about getting older versions to run!

# May 29, 2007 2:34 AM

Marq said:

Now all I have to do is install Vista. :-)

# May 29, 2007 1:14 PM

David Singleton said:

Excellent, this should help a lot of people.

# June 14, 2007 2:58 AM

Erik P. Ernst said:

Very valuable...

# June 14, 2007 5:26 AM

Nuno Maia said:

Good work. This information it’s easy to find it out than partnersource.

# June 14, 2007 7:54 AM

kriki said:

Good work! MS should do the same!

# June 15, 2007 3:08 AM

Gaspode said:

The 4616 traceflag needs to be set for version 5.0 running on SQL2005 database even on XP.

I tried setting it as described in this article and it did not work.

I did a Google on this and found that a - sign is needed before the T. So Startup Parameter should look something like this:

-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T4616

i.e. add ;-T4616 to the end of the existing startup parameter.

# June 20, 2007 7:26 PM

Erik P. Ernst said:

Just a shame you can't lookup the mbs.microsoft links without a special login!

# June 22, 2007 4:39 AM

waldo said:

What would you like to know?  May be I can post it here... .

# June 22, 2007 6:28 AM

babrown said:

I use a simple economics argument to convince customers.

1.  They're most likely buying a server that will support 64 bit

2.  The cost of 32 or 64 bit software (Windows & SQL) is the same.

3.  A 32 bit standard Windows/SQL install will support 2-3 GB of memory

4.  A 64 bit standard Windows/SQL install will support 32 GB of memory.

5.  Adding memory to the 32 bit system will require an upgrade to enterprise editions of both Windows & SQL.  Even with discounts this can be in the $10,000 + range plus memory

6.  Adding memory to the 64 bit system means just buying the memory.

# June 28, 2007 4:20 AM

waldo said:

That is very true indeed ... but not known by many people, I guess.

# June 28, 2007 5:06 AM

David Singleton said:

Hey Eric, great blog. I had thought about going to the WPC, but by the time I decided to go, it was sold out, so its great to get all this information from you.

I totally agree about Upgrades, and although the concept has a way to go, they are going in the right direction this time.

By the way, I know that people don't often reply to Blogs, but a lot of people read them. For example your blog on NAV  on Vista has about 1,200 link backs, coming from google searches, blogger.com, answers.com,

Oh and here is a cool one, someone searched on google.jp and then read your blog in Japanese.

http://translate.google.com/translate?hl=ja&sl=en&u=http://dynamicsuser.net/blogs/waldo/archive/2007/05/28/dynamics-nav-on-vista.aspx&sa=x&oi=translate&resnum=2&ct=result&prev=/search?q=nssdk&start=20&num=20&hl=ja&newwindow=1&rlz=1t4gglj_enjp218jp218&sa=n

Anyway keep up the great work, a real lot of people are reading your Blogs.

# July 9, 2007 5:05 PM

Gaspode said:

Hi Eric,

fantastic report. I don't get chance to go to a lot of conferences (being stuck in NZ) and it's great to find out what's going on. I really appreciate your efforts in blogging.

Nice one - keep 'em coming!

# July 9, 2007 9:20 PM

waldo said:

Thanks for the kind comments, guys.

# July 11, 2007 2:05 PM

Gaspode said:

Hey Waldo, did they say when the new screen saver was going to be launched?

Does the sharepoint portal webpart work with all NAV objects "as is" or do you need to build objects like with the current Employee Portal?

Interesting stuff. Thanks!

# July 12, 2007 4:32 AM

waldo said:

Hey, Gaspode.

I don't know when the screensaver will be launched ... they just said that it's comming.

For the sharepoint client: it will work for all Page objects...   The page object is going to give meta data to the dynamics client.  They built a web part that is also reading this meta data to display on sharepoint.  As simple as that!

# July 12, 2007 12:39 PM

Arhontis said:

To confirm what Gaspode wrote: the actual parameter needed is ;-T4616

(; is the separator from the previous parameter)

Thanks waldo for the great posts here.

# July 13, 2007 3:43 AM

kriki said:

That would be very good, but it would also be needed to define globals/locals as that datatype. Or for the moment to define a global/local AS Item.Description.

So when the description of the item changes, all globals/locals based on it change. This is something I had with Progress and I do miss it a lot in Navision.

# July 23, 2007 8:43 AM

Igor Beeone said:

Good trick :)

# August 6, 2007 5:23 PM

David Singleton said:

Hmm good idea, much easier than putting an icon on every date field in a form, AND its Very Navision like using the ? mark.

# August 6, 2007 8:51 PM

Gaspode said:

Hi Waldo. Yes it would be great. I worked on XAL and then Axapta for a few years before starting on NAV and there are quite a few things that Axapta did much better (for the programmers at least.) I am hoping that the NAV 5.1 and later versions will start to address this. Some things that I miss:

Layers that allow me to easily identify changes and roll them back. Where used in the IDE as opposed to a Developer's toolkit. Fields that do not thow an error if you try to assign a string that is too big. Error messages that get stored up and displayed in an info log. The ability to execute SQL code directly in the database. The list goes on and on...

# August 13, 2007 9:55 AM

David Singleton said:

Hey Eric, nicely written, I am sure its not just you two that didn't know about Index Hinting, so i think this blog will help a lot of people.

Thanks for sharing this.

By the way, if you have problems with SQL using the wrong key in a specific case (e.g., say a form with lots of records), have you tried creating a NEW key specifically for that situation and sorting the form on that, then apply the Hint just to that new key, so that the hinting will not affect other areas of code?

# August 21, 2007 10:11 AM

waldo said:

That's indeed a way to avoid that the key is taken for pieces of code you don't want.  But if you want it to use an existing key ... then you'll have to watch out.  As you know, you can't create double keys... .

# August 21, 2007 10:36 AM

David Singleton said:

You can't create double keys of course, so what I normally do is add a new boolean field to the table, then create a new key including that field, and then filter SETRANGE(MyNewField,FALSE,TRUE);

# August 21, 2007 2:28 PM

waldo said:

That is indeed a way to do it.  Quite a creative tip, thanks.  I will test it out an see what mr. profiler says ;°)

# August 21, 2007 4:00 PM

David Singleton said:

Please let me know the results.

# August 21, 2007 5:51 PM

Marq said:

The setrange is not nesesairy because index hint only uses the setcurrentkey.

# August 21, 2007 6:07 PM

David Singleton said:

Yes of course you are right.

Its an old trick I used to use in flow fields to force Navision to pick the key I wanted it to use instead of letting it pick the first one it finds.

# August 21, 2007 10:30 PM

Erik P. Ernst said:

Since not everyone have access to partnersource, then I'll recommend you to just download it from the download section:

dynamicsuser.net/.../entry90461.aspx

and

dynamicsuser.net/.../entry90460.aspx

# August 31, 2007 5:11 PM

waldo said:

Good call ...

# September 2, 2007 7:12 PM

David Singleton said:

I guess its not NDA anymore Smile I see than Sean has posted some other videos also on You Tube.

# September 2, 2007 8:31 PM

DenSter said:

That is funny! I FEEL GRRRRRRRREAT!!!!!

# September 3, 2007 3:26 PM

Marq said:

Cool!

# September 3, 2007 9:41 PM

Chris said:

I cannot install the fix. I get error "the rollup fix cannont be installed by Windows Installer service because the programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!

# September 5, 2007 10:35 AM

Harry said:

While I was there I saw some Summit Vids - Perhaps I need to find my way to one of these events

# September 5, 2007 11:19 PM

David Singleton said:

For sure Harry,

if you only get a chance to make one event, then Summit is the one to be at.

That summit video there was made at the party we had at the Museum of Flight, which was a great night out.

# September 6, 2007 11:16 AM

Erik P. Ernst said:

This is very good. But the question I remember always hearing is: What's in it for me?

# September 7, 2007 10:07 PM

babrown said:

See my comment to Waldo's previous blog. Remember you're dealing with financial systems people.  They understand things in terms of "what will it cost me"

dynamicsuser.net/.../sql-server-x64-vs-x86.aspx

# September 9, 2007 12:47 AM

waldo said:

This table was actually an extension to my previous blog, where babrown already summarized what is actually in it for NAV customers... .

# September 10, 2007 8:47 AM

Peter W said:

IMHO indexhinting will not do the trick for one simple reason: SetCurrentKey is only significant for sorting and not for selection. The index to use therefor does not depend on the active key but on the fields on which is filtered.

The indexhint option actually gets "in the way" when there are 2 routes to the same screen, i.e. Customer Ledger Entry screen can be reached through the Navigate functionality (where the filter will be on "Document No.") and from the Customer form (where the filter will be on "Customer No."). The resulting screen has the SetCurrentKey set to "Customer No.", "Posting Date" so for the "Document No." route with index hinting to the Customer No. index will still result in a freeze.....

And still, users are allowed and will use the function to change the Sorting Order in this screen (effectively changing SetCurrentKey) with similar performance impact.

# September 10, 2007 1:55 PM

waldo said:

Well, actually, in NAV terms ... with indexhinting, you can USE SETCURRENTKEY to be sure to take the key you want, despite what SQL Server would suggest.  That's the whole idea of index hinting: SQL Server doesn't take the key you want it to take .. so you hint that key.

About the two routes: David's suggestion is the way to fix that.

# September 10, 2007 2:11 PM

Erik P. Ernst said:

Thanks, I look forward to see the "what's changed" list...

# September 11, 2007 2:07 PM

Erik P. Ernst said:

Well Mark actually also posted it to his own blog here:

dynamicsuser.net/.../update-6-for-navision-4-0-sp3-be-careful.aspx

# September 14, 2007 1:44 PM

Vincent said:

One thing is for sure, if it was not for Arhontis's posting I would have had a really bad weekend.

The ;-T4616 solved my problem.

# September 14, 2007 8:47 PM

ImmanyJal said:

You'll be up a creek whenever an urgent medical bill or emergency spring up, and your payday is still far out. If an overnight $500 personal loan can help, ...<a href=abaco.ya.com/.../index.html>no fax payday cash advance</a>

# September 15, 2007 11:22 AM

waldo said:

I changed the screenshot to the ";-T 4616" ... .

# September 16, 2007 12:45 PM

kriki said:

You should update this blog with the new updates!

# September 19, 2007 12:26 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

Review: One of the discussed new features in update 6 is the fact that the new client (build 24143),

# September 19, 2007 2:38 PM

DenSter said:

Thanks for the elaborate article Eric, very useful and informative

# September 19, 2007 2:47 PM

waldo said:

Thanks, Daniel.  I have a "writing memory".  If I want to remember something, I have to write it down ... and these days ... I'm writing it directly into a blog post Smile.

# September 19, 2007 2:59 PM

Nuno Maia said:

Thanks for information, this probably will save me from a lot of work in future

# September 19, 2007 4:15 PM

waldo said:

Thanks, Martin.  That is exactly the info we needed... .

# September 19, 2007 7:49 PM

Algirdas said:

you said that it accumulates previous hotfixes. does that include KB931841, KB933727, KB936602 and KB938138?

# September 20, 2007 2:32 PM

Algirdas said:

So correct me if i'm wrong: if we update to this version, to preserve exact same behaviour as previous versions, we have to

INSERT INTO [$ndo$dbconfig] VALUES

('IndexHint=No’)

on each installation. Correct?

# September 21, 2007 7:49 AM

waldo said:

Indeed, tested and approved.

# September 21, 2007 8:10 AM

DenSter said:

It would be great if those sessions could be recorded and made available for download.

# September 28, 2007 6:12 PM

waldo said:

Ok, I will do my best.

# October 1, 2007 7:54 AM

David Singleton said:

Basically Microsoft at EVERY office have the technology setup to create and record live meetings. This wont be an issue of technology, but one of IP. Basically do they want to share the information.

If the event is sponsored by Dynamics, then I would guess they would want the information shared. If its MSDN paying the bill, then its a different issue. They would most likely only want it shared through MSDN or TechNET. Which sounds pretty fair to me. In that case they can publish it through the MSDN secure downloads section, and make it subject to MSDN NDA which should cover all bases.

Of course ideal would for this information to be made public.

# October 2, 2007 10:45 AM

waldo said:

I talked with the organizers, and really, it's just an infrastructural problem.. .

# October 4, 2007 8:21 AM

Erik P. Ernst said:

Hehe! Somehow with my almost 20 years in the industry (17 with Navision) I sort of have heard this story before! Incompetense! But you not only find this with Microsoft, but in general with most companies in the industry! It's sad...

But to you entry about the runtime license. What should actually be the advantage of the runtime license over the normal licenses?

# October 4, 2007 10:01 AM

waldo said:

Very simple: the price.  Runtime is cheaper.

# October 4, 2007 10:55 AM

Erik P. Ernst said:

Ok, good reason, but by how much? And aren't there any other downsides than the fact you can only run one database? And what about the default databases (master, mdbs etc)?

# October 4, 2007 11:12 AM

waldo said:

How much I don't know.  It depends on the reseller price.  The difference was about 5250 EUR in our case.

# October 4, 2007 11:24 AM

waldo said:

Also ... it's a full SQL Server.  master, mdbs etc are all include.  they don't count as a Dynamics database.

How they check it how many database are installed, I don't know.  I even don't know if it is checked at all Wink ...

# October 4, 2007 11:25 AM

Erik P. Ernst said:

Ok! I'm basically asking not so much for the reason of Dynamics - more because I'm currently running this website on a SQL Server workgroup edition, and was interesting if it was better to change this with a runtime version!

# October 4, 2007 1:08 PM

waldo said:

As far as I understand, a "Runtime" is compiled for a specific product (in this case Dynamics).  I doubt there is a runtime for community server.

# October 4, 2007 1:16 PM

Erik P. Ernst said:

Ok :(

# October 4, 2007 1:18 PM

David Singleton said:

Hey get them to see if they can contact the MSDN or TechNET people, since they are the experts in that area.

HeHe Wink

# October 4, 2007 4:10 PM

babrown said:

The runtime license is a fully functonal copy of SQL.  The only difference is the legally allowed use.  You are restricted to running only the application with which it was supplied.

# October 8, 2007 1:04 PM

babrown said:

With publicly accessible SQL servers (i.e. Websites) the only valid license is a processor license.  Microsoft requires this because you cannot control the number of people connecting to the system.  Also with processor licensing all Microsoft software, on the server, must use processor licensing.  That mean both Windows Server and SQL.

This can be an issue for Navision sites that expose access to customers via websites.

# October 8, 2007 1:17 PM

Erik P. Ernst said:

Thank you. Very helpful. It would have been nice also to have the release dates in the list.

# October 8, 2007 4:04 PM

Timo Lässer said:

Very useful list! Many thanks to you.

I have a suggestion too:

Could you make the Major Release Version be a hyperlink to the download page in PartnerSource?

# October 8, 2007 4:31 PM

themave said:

My understanding with the runtime license is you can't use external programs to access the database either, if you want to run some web services or something to connect to your database you need the full version

Note:  Microsoft SQL Server 2005 Standard Runtime Edition is sold on a per “NAMED” user basis.  This requires a customer to license a SQL User for each person accessing the system.  The number of SQL users must be equal to or greater than the number of Professional users on the license. Microsoft SQL Server 2005 Standard Runtime Edition is licensed only as a platform to the Navision product. A full SQL license is required to support any third party products including, but not limited to, other Microsoft products not sold on the Navision price list.

# October 8, 2007 5:24 PM

Asier said:

I've got build number 22979 but I don't found here (4.0 SP2).

Thanks.

Asier

# October 9, 2007 8:23 AM

waldo said:

could it be a private hotfix?

----

I added the links to the major releases.  The older versions didn't have one page with all country versions, so I just picked the NA or W1 version... .

Enjoy!

# October 9, 2007 8:35 AM

microsoft » New Release Date for Microsoft Dynamics NAV 5.1 said:

Pingback from  microsoft &raquo; New Release Date for Microsoft Dynamics NAV 5.1

# October 11, 2007 5:37 PM

Xbox » New Release Date for Microsoft Dynamics NAV 5.1 said:

Pingback from  Xbox &raquo; New Release Date for Microsoft Dynamics NAV 5.1

# October 11, 2007 5:39 PM

New Release Date for Microsoft Dynamics NAV 5.1 said:

Pingback from  New Release Date for Microsoft Dynamics NAV 5.1

# October 11, 2007 6:10 PM

Erik P. Ernst said:

Not really a surprise. But it's "nice" to see it on writting. Changing the version to 6.0 really does make sense.

But who want to bet that we don't see it until 2009? Wink

# October 11, 2007 10:14 PM

Nuno Maia said:

Version 6.0 it’s almost a completed redesign of Navision. So it’s natural that MS is trying to achieve a solid product and it takes time.

Erik I also bet in 2009...

# October 11, 2007 11:38 PM

waldo said:

Well ... the release date is always W1, so I guess any localized version will be in 2009...

# October 12, 2007 7:33 AM

DenSter said:

I am not betting on anything, but I am not expecting anything in 2008.

# October 12, 2007 2:44 PM

David Singleton said:

Well we need W1, then we need Localizations, then we need six months before we see the Upgrade Took kits, so...

Lets get back to selling 5.00 Smile

# October 15, 2007 2:24 PM

Erik Nielsen said:

I think using sp_create_plan_guide with OPTION (RECOMPILE) may be the best solution.

SQL don't select the right index because of plan cache and/or OPTION (FAST xx).

In sql2005 the recompile is more selective than in sql200 and that may be one of the reasons for this problem.

Using Index Hints will forse SQL to use ineffective index.

In my NAV 4.03 running sql2005 I have found 18 selects with bad performance because of wrong index. After insert of selects in sp_create_plan_guide performance is fine.

I this way you keep recompile on a very low level.

# October 19, 2007 10:35 AM

Windows Vista News said:

Did you see the post at dynamicsuser.net

# October 19, 2007 2:45 PM

Microsoft?? SQL Server??? Reporting Services and Style Sheets … said:

Pingback from  Microsoft?? SQL Server??? Reporting Services and Style Sheets &#8230;

# October 19, 2007 2:46 PM

David Singleton said:

Hey Eric, thanks for this, pity we cant have this in all countries, but at lest with your Blogs we get some of it.

Keep up the great work.

# October 19, 2007 5:18 PM

Vincent said:

Hi Waldo, thanks for the update. Really nice for the ones that couldn't make it to the conference. Some people work, you know ...

Regarding the sure step methodology:

Sure Step does not oblige to implement full blown methodology as it provides guidance for all types of projects in all types of companies. That means that it provides guidance for a large complex project in a large company as well as a simple project in a small company.

The tools and the approach of the project manager in both scenarios will be necessarily different.

Except for that sure step is providing a lot guidance and tools that are accepted by all standard project management methodologies (prince2, PMI, ...). These tools are at disposal of the project manager when he thinks he needs them.

It is my personal opnion that if you want to implement Sure Step you need to be familiar with standard project management techniques (check my blog regarding a number of these basic techniques. If you master these techniques, sure step will not only be a nice tool. Only then it will be the key for your project success! If people don't master these techniques, sure step will only document their failure.

Good news is: Plataan offers not only sure step training (in 2 formulas: overview and in detail) but also standard project management training.

Cheers, Vincent - Dynamics MCT

PS: keep on updating us through your blog about Convergence. Super!

# October 23, 2007 10:58 AM

waldo said:

Thanks for the update, Vincent.  I know there is a lot of Sure Step knowledge with you ... Smile.

# October 23, 2007 11:41 AM

Kine said:

Thanks for that info... :-)

# October 23, 2007 12:19 PM

Poemeatevem said:

A man is trying a very unusual way to propose to his girlfriend. He wants people to forward an email to as many people as possible and he hopes that it will eventually get to his girlfriend. Details here: www.proposal-to-mary.com

Here is what he wants people to send by email:

You could help me a lot to spread my proposal to Mary – it is important that it is distributed as widely as possible so that it eventually reaches Mary. If you would like to support my proposal to Mary, please send the following text by email to a lot of people :-)

------------- SNIP (email text end) ---------------

WHEN YOU RECEIVE THIS, PLEASE HELP TO DISTRIBUTE IT TO OTHER PEOPLE!

For a long time I have tried to find a special way to propose marriage to my girlfriend Mary, whom I know for five years now. I wanted it very special, romantic and memorable, something our grandchildren would still remember.

And here is my idea: I will send out the proposal to Mary to 50 complete strangers, people I don't know - hoping, that they will forward my proposal to as many people as possible, which in turn forward it etc. And some day, I hope, it will reach Mary, after it has travelled a very long way. I know, it will take a long time and I am quite nervous…

From the poem MY Mary will know immediately that the proposal is for her.

I have created a homepage ( www.proposal-to-mary.com ) where you can find the current status of my quest. You can use the homepage to check if the proposal has already reached Mary (in that case it is not necessary anymore to forward the mail).

Once the proposal has reached Mary, I will put a note on these pages. Also I will publish there how many people have read the proposal so that everybody can see how far it has spread and that it is getting closer to Mary.

And of course you will find there what I am waiting for most: Mary's answer! I can't tell you, how nervous I am… Will she accept my proposal? Will she like the unusual way how she got it, through the hands of thousands of messengers all over the world?

Please cross your fingers for me! And please - help me by sending the mail to as many people as possible, to help it spread, so that it eventually reaches Mary.

And here is my proposal:

Mary, please forgive me, as you know English is not my native language. And I am not a poet. But I mean it from my heart.

My angel,

Five years ago, I will always remember the day When fate made us meet, blissful Alaskan moments in May Earth spun around us and a journey began Love, warmth, happiness, enough the years to span.

The longer it lasts the more grows our bond And with 80 still - of you I will be fond Whatever happens, I will stay at your side Through good and bad, together let us stride

No second with you was ever wasted

You are the sweetest I have ever tasted

We have spent so many years - why not a life?

Mary, will you marry me - and become my wife?

Mary, if you have received that and have recognized me, then give me a sign so that I can continue with the romantic part of my proposal…

------------- SNIP (email text end) ---------------

# October 23, 2007 6:13 PM

Lugly said:

We were close to rolloing out our fundraising group on V4 when our partner tested and upgraded us to V5.  We are now ready to cancel the rollout because of poor performance.  MS said they are working on the speed issue but could not give me a date.

# October 25, 2007 7:10 PM

J.D.S. said:

That's what I call cross-selling. Anyway: Thanks for the interesting blog.

# October 26, 2007 5:56 PM

David Singleton said:

I was really happy with the new format of this presentation. Last year it was very technical, and in one hour you just can't do that. This years presentation was a great overview, and the sort of thing that lets you know all the areas you need to look at, and some starting points of where to go next. Think of it as "Hello World" for people implementing NAV on SQL.

# October 28, 2007 9:01 AM

waldo said:

I agree ... Smile

# October 28, 2007 10:36 AM

Marq said:

Me too.

Last year it was all new but it seems that the basic knowledge is generaly available know.

It is up to methodolgy and partner community now.

I love being part of the SQL Perform community.

# October 28, 2007 5:48 PM

waldo said:

Part?  I think you run that community ... Wink

# October 28, 2007 7:18 PM

Marq said:

Only in Holland and Belgium :-)

# October 28, 2007 7:50 PM

Jörg A. Stryk said:

Well, I as a competitor of SQL Perform ;c) found it somewhat annoying that permanently the SQL Perform Tools were mentioned ;c)) ignoring the fact that other magnificent optimization software is availabe, too ;c)))

But seriously: even from a more objective perspective I think it was too much advertisement and less content. I prefer last year's session.

# October 29, 2007 12:52 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

As expected, Agiles started out with some figures about themselves: Australian NAV partner sincs 1993

# November 8, 2007 9:08 PM

Techy News » Blog Archive » Directions Diary - ISV Session - Handapps: Mobile Solutions said:

Pingback from  Techy News  &raquo; Blog Archive   &raquo; Directions Diary - ISV Session - Handapps: Mobile Solutions

# November 9, 2007 12:34 AM

Erik P. Ernst said:

Great post! It sounds like Directions is much better than Convergence!

# November 9, 2007 12:40 AM

agiles2007 said:

Hello Waldo and others,

I am Mandy Dore from agiles, who presented agileWorkflow yesterday at Directions 2007.

I thought I should let you know that agiles are a Germany company, based in Hamburg. I am orginally from Australia, hence the confusion. :)

Also, the Markant example was not intentially made complicated, but yes you are right, they did have complicated processes that were made simple by the implementation of agilesWorkflow. But Markant is just one example.

It is quite difficult for you to convey all the information from the session into a short blog, so for those who are interested in understanding more, please contact me directly on mandy.dore@agiles.net.

And Waldo, I would love to make you fully convinced, ;) so let's discuss it further together.

Mandy.

# November 9, 2007 3:29 PM

waldo said:

Ai, didn't expect anyone to read my blog Indifferent.

# November 9, 2007 4:32 PM

Erik P. Ernst said:

Was it Helen who spoke at the session?

# November 9, 2007 10:27 PM

Erik P. Ernst said:

Wasn't this a bit strange session title? I mean at what point are anyone migrating from C/SIDE (short for client/server integrated development environment) to SQL. Based on what you described above it sounded more like a session on migrating from the native database to SQL.

Well but still interesting!

# November 9, 2007 11:34 PM

Erik P. Ernst said:

Well I think a lot of people are reading it. In fact more than the view number say, as the view number doesn't include those who read it from RSS...

# November 9, 2007 11:37 PM

Alex Chow said:

It is. Based on a short description from Mark, it's basically "how to upgrade your C/SIDE database to SQL without losing your client".

# November 10, 2007 3:19 AM

waldo said:

Actually the real session title was "changing alphabets", but that doesn't say much to most people.  That's why I changed it to "Migrating from C/SIDE to SQL".

# November 10, 2007 7:10 AM

waldo said:

I can't say, because I arrived late at the session, and I missed that ... .

# November 10, 2007 7:13 AM

Erik P. Ernst said:

Ok, I just ask because I have know Helen Russel of SCS for many years. She's a very nice lady, the owner of SCS...

# November 10, 2007 11:24 AM

Erik P. Ernst said:

Nobody like that anyone is getting something before others. And especially in the Dynamics NAV world there has always been a lot of jealousy between the partners. And now after MS introduced the MVP's, then they just point their eyes toward the MVP's instead! The only real difference is that before MS, all the beta programs where secret!

Btw. what is a PAM?

# November 10, 2007 12:39 PM

Erik P. Ernst said:

The sessions at Directions sure sounds much better than Convergence! I know they will have it next spring in Paris, but does anyone know when?

# November 10, 2007 10:37 PM

icrocker said:

Interesting post, and a subject close to my heart - glad to see it's being discussed.  

I think the maintaining of correct object information in Object Designer should also be included in the discussion on standards.  How many times have you seen an object marked as modified, with no version list change and no comments in the Documentation trigger?  

# November 11, 2007 1:14 PM

Kine said:

Thanks for that info. Good to know that...

# November 12, 2007 7:11 AM

waldo said:

If I'm not mistaken, the Paris Directions will be held from 16-19th of April 2008.

# November 12, 2007 7:12 PM

waldo said:

I asked and yes, it was her Smile.

# November 12, 2007 7:12 PM

waldo said:

PAM = Personal Account Manager.

It the first point of contact at Microsoft for a MS Dynamics NAV Partner

# November 12, 2007 7:13 PM

David Singleton said:

And guess what other event is on that week Sad

# November 13, 2007 3:28 AM

waldo said:

Yeah, that sucks.  I really would have liked to go to the summit.

# November 13, 2007 8:42 AM

Timo Lässer said:

As Eric wrote in the previous Blog posting (dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0.aspx):

"It would have been nice also to have the release dates in the list."

Please try to get and publish these dates. Thanks for your affords in advance.

P. S.: Still a very usefull overview! *Thumbs up!*

# November 14, 2007 7:30 PM

Timo Lässer said:

FYI: There is a new (updated) posting by waldo availible:

dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0-update-1.aspx

# November 14, 2007 7:32 PM

Marq said:

Thanks for the blog Waldo!

I really enjoyed presenting and preparing for the event. Thank you for your input.

I noticed that a lot of people just do not know the risks in migrating until their fist project fails.

Good thing that Micheal Nielsen, Kim Ibfelt & Darren Layborn were there and noticed the issue.

It did put a little extra pressure though to have these guys on the first row.

# November 15, 2007 1:59 PM

Marq said:

Funny also to see a blog about my own session thinking I was the one who started blogging at TechEd only 18 months ago.

Now I am presenting myself...

# November 15, 2007 2:03 PM

waldo said:

No prob, glad that I had the chance to review the slides, else it wouldn't have been so good SmileSmile hehe.

To be honest, the slides and the structure of the session would be a good beginning for some kind of migration course.  May be a chapter for in Dave's next book? Smile

# November 15, 2007 2:23 PM

Marq said:

What I will do is migrate the slides to a whitepaper and upload to the downloads of our forums.

# November 15, 2007 3:11 PM

waldo said:

That would be very useful.

It doesn't have to be a white paper, "best practices" is also good Smile.

# November 15, 2007 3:25 PM

waldo said:

I didn't search yet, but can you point me where I can find the release dates?

Furthermore: the links didn't work, but now they do Indifferent.

# November 16, 2007 10:19 AM

Jörg A. Stryk said:

I'd like to add this one:

4.00 SP3, Update 7, Build 25307, KB943227

# November 17, 2007 11:30 AM

R-kwadraat said:

As I am working as a freelancer I do not have the rights to view the microsoft knowledgebase. Is it possible to publish this information here.

For those that are also working as freelancer and not being a MVP how do you get the latest information about the Dynamics products?

Greetings, Remco

# November 19, 2007 9:23 AM

waldo said:

I don't find anything about KB943227.  Jorg, can you give an URL?

# November 19, 2007 10:16 AM

Marq said:

mbs.microsoft.com/.../KBDisplay.aspx

Here's the link.

Remco, that is the reason Eric posts it. He is getting it because he pays MS a lot of money and shares it for free afterwards.

There is no way to get access to partnersource as a freelancer. If you want an update, contact the partner of the customer you are working for and request it. You should never implement a hotfix anyway without telling the partner.

# November 19, 2007 9:05 PM

waldo said:

That is not entirally true.  As partner, you can get the info from partnersource.  You don't need to pay extra.

We have a PABS agreement that gives us many advantages.  Amongst the advantages is proactive info.  When something interesting is published on partnersource, I get it by mail.  Now, I must say, most of these kb articles were NOT sent by mail!

I updated the list with update 7.

# November 20, 2007 8:15 AM

R-kwadraat said:

Hé Mark,

I know the link, but the that doesn't solve my problem. I will try if the partner will give me the extra information. And off course the partner does know that i'm using this hotfix!

Greetings

# November 20, 2007 10:07 AM

Waldo's Blog
Microsoft Dynamics NAV
said:

When I was on the plane to New York a few weeks ago (After Convergence, but before Directions), I wrote

# November 23, 2007 11:17 AM

Kine said:

The "Error" bug in CU 1 is known. It is problem of the CU1. Workaround is to call message instead and right after the message call Error(''); It will work as error, message will be showed correctly (but just with the "i" icon instead exclamation).

# November 23, 2007 1:36 PM

waldo said:

I talked with some developers about this, and it was indeed quite known.  The workaround with the Message and Error('') I did not get from them and I will test it out... .

Thanks, Kine!

# November 23, 2007 1:50 PM

Geert said:

Thanks Eric! It workes!

# November 28, 2007 10:16 AM

waldo said:

Almost got it right ... changed the "low changing fruit" to "low hanging fruit" Indifferent.

# December 4, 2007 6:18 PM

Vincent Bellefroid said:

Hi Waldo, nice blog-article. I will refer future students to this when explaining when to use the fob and when to use the txt format for objects.

Cheers

Vincent

Microsoft Dynamics MCT

# December 5, 2007 9:47 PM

waldo said:

Hey, that's cool Smile.

I wrote the article, but I was doubting to put it online.  Glad I did though Wink.

# December 6, 2007 8:19 AM

David Singleton said:

Yes Eric, very useful blog, I am sure it will help a lot of people.

Just to add to this, you can also do this in the normal C/SIDE editor without every having to export anything. Like this:

Find all the objects that have the Optin used.

Open the object, and start to save it.

At the prompt to save Yes/No de-select the object to compile.

(So save the object un-compiled)

Repeat for all objects.

Now go back to the tables with the Options.

Change the option string.

Repeat for all the required tables.

Now select all the objects that are un-compiled.

Hit F11.

Since the objects were saved in text format, its just like using a text editor, in that the integer value is not used.

# December 6, 2007 12:22 PM

waldo said:

Thanks for sharing this, David.

It actually makes we wonder.  If you save the object uncompiled ... and you export the object ... do you get the text file in stead of the fob file?

Smile

# December 10, 2007 8:40 AM

David Singleton said:

Yes that's correct. If you export an uncompiled object, then you only export the text. When you compile it you export both the executable object AND the text.

# December 10, 2007 9:34 AM

kriki said:

An extra remark for adding an option to an existing list of options:

Not just add it to the end, but add some , before it.

In general I start to use the 20th value for the next option. This way, you leave some space for future standard options.

E.G.

"FIFO,LIFO,Specific,Average,Standard"

becomes

"FIFO,LIFO,Specific,Average,Standard,,,,,,,,,,,,,,,Waldo"

If tomorrow MS decided to do this:

"FIFO,LIFO,Specific,Average,Standard,Some MS Value", you do not need to change the value of option "Waldo" in the database.

Also use this in the option-captions.

The beautiful thing is that the empty option-values are NOT shown between the possible option to choose from.

# December 10, 2007 6:03 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

# December 11, 2007 10:55 AM

Waldo's Blog
Microsoft Dynamics NAV
said:

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

# December 11, 2007 10:55 AM

Waldo's Blog
Microsoft Dynamics NAV
said:

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

# December 11, 2007 10:55 AM

Bram De Daele said:

@ Find statements: Steven said MS is "beginning to" replace the FIND('-') with FINDFIRST where necessary, in their new development and in the code they "review" (that's what I understood).

He DID say that these 2 statements did two different things... :-)

If you need the ppt, I can send it to you (left you a message via "contact").

# December 11, 2007 2:58 PM

waldo said:

@ Find statements: let's just say that things are not clear yet, and are still not clear for many people Smile.

I did not get a message yet, but thanks already Smile.

# December 11, 2007 3:06 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

# December 13, 2007 10:55 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

# December 13, 2007 10:55 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

# December 20, 2007 3:00 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

# December 20, 2007 3:00 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

# December 20, 2007 3:00 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

Here is your reporter back with more news about the Belgian MSDN/Technet evenings . This time, the topic

# December 20, 2007 7:47 PM

Windows Vista News said:

Did you see this post at dynamicsuser.net

# December 24, 2007 3:00 PM

Tom Mertens [MSFT] said:

Indeed, we have such a recording device and I really hope that we'll be able to record all the next sessions. In the near future we should also get a second device so if there are more sessions at the same time, we'll record them all. See you next time.

# December 26, 2007 3:58 PM

Windows Vista News said:

There is an interesting post over at dynamicsuser.net

# January 6, 2008 1:00 PM

Pages tagged "microsoft" said:

Pingback from  Pages tagged "microsoft"

# January 6, 2008 1:31 PM

pdj said:

Great stuff! I was actually working on a private NAV-ADO project at the very moment I noticed your post in Google Reader :-) My project might show up in the Mibuso downloads if I get it to work ;-)

Only comments:

* You should mention the risk for SQL-Injections. An evil person with permission to create companies could execute any SQL statement in your database impersonating the service user with this solution.

* You should mention the possibility of using "Integrated Security=SSPI" to use the credentials of the current AD user instead. (Some times it is a better solution, sometime not)

But a yet another great article - keep'em coming :-)

# January 6, 2008 3:13 PM

waldo said:

Thanks pdj for this info.  It is indeed something to watch out for.  I know I didn't handle security very well in this post, so your comments are very valuable... .

# January 7, 2008 9:57 AM

waldo said:

Just wanted to wish y&#39;all happy holidays!!! To cover everyone, here are the greetings in most languages

# January 10, 2008 4:16 PM

waldo said:

Recently, I had to do a small project. A client of us wanted to see the global inventory of all its companies

# January 10, 2008 4:16 PM

waldo said:

Here is your reporter back with more news about the Belgian MSDN/Technet evenings . This time, the topic

# January 10, 2008 4:17 PM

waldo said:

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

# January 10, 2008 4:17 PM

waldo said:

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

# January 10, 2008 4:17 PM

Natalie said:

I have two new build Nos

5.0.25581.0 (KB944919) latest one!

5.0.24632.0 (KB936885)

# January 11, 2008 1:07 PM

waldo said:

Do you have URL's as well, because i can't find them in the knowledge base?

# January 11, 2008 1:47 PM

waldo’s blog » Blog Archive » Using ADO & Stored Procedures in C/SIDE said:

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Using ADO &amp; Stored Procedures in C/SIDE

# January 15, 2008 7:01 AM

waldo’s blog » Blog Archive » Merry Christmas & Happy New Year said:

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Merry Christmas &amp; Happy New Year

# January 15, 2008 7:02 AM

waldo’s blog » Blog Archive » Platform updates overview ??? 3.70.B ??? 5.0 Update 1 said:

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Platform updates overview ??? 3.70.B ??? 5.0 Update 1

# January 15, 2008 7:02 AM

Natalie said:

You don't need to know any URL if you know the KB No.

Example for KB944919:

mbs.microsoft.com/.../KBDisplay.aspx

# January 16, 2008 2:05 PM

kriki said:

Directions EMEA 2008 : http://www.directionsemea.com/

# January 17, 2008 2:01 PM

Alex said:

And what about update KB945349 for 4.0 SP3?

# January 17, 2008 3:12 PM

waldo said:

You're right.  I added this one.

It seems that I don't get proactively informed anymore Sad.

# January 17, 2008 3:23 PM

waldo said:

Thanks to Natalie, I added two more updates on 5.0. This is the new overview. Released Version Update

# January 17, 2008 3:28 PM

Natalie said:

Waldo, I think that you have mixed up some info:

KB 945349 (4.0 Update 8) includes two  Build Nos.: 5.0.25653.0 and 4.0.3.25638.

Hence 4.0 Update 8 has to be Build No. 25638 instead of 25653 in your list.

Build 25653 for 5.0 is missing.

:-)

# January 17, 2008 9:44 PM

waldo said:

You are absolutely right.  Thank you very much for the info.

It's becoming quite complicated with all those updates I must say.  

# January 18, 2008 8:53 AM

waldo said:

It is not too late ... but still late. I haven&#39;t said a word about Directions EMEA 2008 yet, while

# January 21, 2008 8:49 AM

Windows Vista News said:

There is an interesting post over at dynamicsuser.net

# January 21, 2008 9:00 AM

waldo said:

I am happy to announce Outlook Integration Update for Microsoft Dynamics NAV 5.0 . This update is now

# January 24, 2008 4:06 PM

Guido Robben said:

Does anybody know why they changed Codeunit 418, 448, 449.

I couldn't find anything in the whitepaper or website why they changed the objects.

# January 28, 2008 4:30 PM

Erik P. Ernst said:

I'm kind of in doubt here. Especially after reading the different KB articles.

With a fresh new SQL 2005 64bit server and NAV 4.0 SP3, which update should we take?

# January 28, 2008 7:17 PM

waldo said:

I would go for Update 8.

# January 28, 2008 10:42 PM

Erik P. Ernst said:

Where can they be downloaded?

# January 29, 2008 10:21 AM

waldo said:

This is explained in the KB article.  You have to request the hotfix from Microsoft.

# January 29, 2008 10:44 AM

waldo said:

This is a very challenging blogpost in my opinion. I see many stories going around on what would be the

# February 1, 2008 10:02 AM

Tomas said:

Interesting!

Looking forward for article "monitoring your code"

# February 1, 2008 12:42 PM

AlexP said:

Great Post - Lots think about !!

# February 1, 2008 1:15 PM

Nav user said:

Does 2.6 support x64?

# February 1, 2008 2:37 PM

waldo said:

No, it does not, I'm afraid. You need a special x64 xp_ndo.dll as well.

Is a runtime upgrade an option?

# February 1, 2008 2:49 PM

Nav user said:

Well, we are currently using 2.6/2000 and looking to upgrade the server, trying to take advantage of more RAM, but only can with x64

# February 1, 2008 3:29 PM

waldo said:

Indeed ...

# February 1, 2008 4:05 PM

Nav user said:

So, given the info above, it looks like AWE as you describe would be our best alternative, right?

# February 1, 2008 5:47 PM

waldo said:

Indeed.  The switches in boot.ini and AWE in SQL Server seem to be your things to use...

# February 1, 2008 6:34 PM

kriki said:

To avoid the "NEXT FROM HELL" (this perfectly describes the proble!), my advice is:

If you have a loop and in it you want to change a field, ALWAYS use a second variable. Why do I say this?

1) this rule is easier than "If you have a loop and in it you want to change a field and that field ........."

2) If you don't have the problem, but later some other programmer (or also you) has to change another field in it it can become a "NEXT FROM HELL" and you have to change your code (and most of the times the other programmer doesn't do this!).

# February 4, 2008 8:11 AM

Soft Tod said:

Great post.

Clears the fog somewhat ;)

What I miss in general is the behaviour using the MARK functionality as it also is a way of filter data. Sometimes I use MARK instead of a second record to avoid the "NEXT TO HELL" trap.

# February 4, 2008 9:24 AM

waldo said:

Please, try to avoid using MARK on SQL Server.

It is very difficult for SQL Server to figure out what to do with it.  It is not unlikely all queries will result in table scans - many database calls - or whatever - because it is not possible to use a decent filter (which results in a decent WHERE-clause in SQL Server)... .

# February 4, 2008 9:47 AM

TRZ said:

Interesting post. But what about using any secondary key in a Findset-Loop?

Your results on counting fetches and/or selects would be heavily different. I recommend using a FINDSET only in loops wehre you know that there are less than "500" records in the resultset. If you are using FINDSET with a key different to primary key you will cause many selects. The "select top 501 *" do not create a trigger, so there ist no way to fetch the next records behind 501.

By the way, it's the same damn thing when you are using a FIND(-) in a loop with modifying records. If you do not use locktabe (or findset(true)) you will get many new selects while looping if you use a key different to primary key.

# February 4, 2008 9:56 AM

Gaspode said:

Thanks once again for the extra effort you put in to help the NAV developers of this world. God knows we need all the help we can get.

# February 5, 2008 1:06 AM

Erik P. Ernst said:

When is the book "Advanced Dynamics NAV Programming" going to be published?

A very good post! Keep them coming and soon you have material enough for the book!

# February 5, 2008 10:10 AM

Erik P. Ernst said:

Actually I also got a question on this I would like to hear your experiences on.

A long time a go I was told that using the MODIFYALL was always a very good option. But how is SQL Server actually treating this command?

I mean if I need to update two fields?

Example 1:

SETRANGE(MyField,'FILTERVALUE);

MODIFYALL(MyOtherField,'NEW VALUE');

MODIFYALL(MyThirdField,'ANOTHER NEW VALUE');

Example 2:

SETRANGE(MyField,'FILTERVALUE);

FINDSET(TRUE);

REPEAT

 MyOtherField := 'NEW VALUE');

 MyThirdField := 'ANOTHER NEW VALUE';

 MODIFY;

UNTIL NEXT=0;

Which example would be better?

And what if ex. we had to call the VALIDATE trigger?

# February 5, 2008 12:31 PM

kriki said:

I think example 3 is best:

RESET;

SETCURRENTKEY(...);

SETRANGE(MyField,'FILTERVALUE');

FINDSET(TRUE[,TRUE]);

REPEAT

 recOtherRecord := rec;

 recOtherRecord.MyOtherField := 'NEW VALUE');

 recOtherRecord.MyThirdField := 'ANOTHER NEW VALUE';

 recOtherRecord.VALIDATE(MyFourthField,'YET ANOTHER NEW VALUE');

 recOtherRecord.MODIFY(FALSE); // or (TRUE);

UNTIL NEXT=0;

And if you have a VALIDATE-trigger, it is impossible to use MODIFYALL.

# February 5, 2008 4:06 PM

Tarek Demiati said:

Nice article, it's indeed a smart idea to use the SQL profiler in combination with Client Monitor to find how record set manipulation CAL get spitted out in SQL statements :-)

Best Regards from France,

Tarek Demiati

Freelance Dynamics NAV (Navision) Developer

# February 5, 2008 10:21 PM

waldo said:

Thank you for the kind messages.  Who knows there will be a hardcopy bundle some time Wink.

Let me create a "part two" blog post where I will handle MODIFYALL, DELETEALL and MARKing records, OK?

# February 5, 2008 10:28 PM

Erik P. Ernst said:

That's what I say Eric, soon you'll have enough for a small book! Wink

# February 6, 2008 7:58 PM

Dynamics NAV Tech & NAV in Baltic said:

Few new articles about NAV on SQL released by experts: Lars Lohndorf-Larsen article "Record-level locking

# February 8, 2008 2:40 PM

David Roys said:

Hi Waldo, have you ever done this for a SQL 2005 database? We have some code that worked on SQL 2000 and now get an error saying that the SQL-DMO cannot be used to connect to the server and you must use SQL Server Management Objects (SMO) instead.

# February 11, 2008 3:57 AM

waldo said:

Hm, strange.  I wrote the above using an SQL2005 database...

# February 11, 2008 9:43 AM

gravity7 said:

Problem

I cannot install the fix. I get error "the rollup fix cannont be installed by Windows Installer service because the programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!

Solution

First install the client and then install the roll up patch.

# February 12, 2008 7:31 PM

waldo said:

That is absolutely right ... and that counts for all platform updates.  You have to have an installed client of NAV, else it won't find it to update... .

This is a problem for partners/developers/consultants, but usually not for end users.

# February 12, 2008 9:34 PM

mohlabetsi said:

Great you keep this up to date Waldo. I always read your Blogs with great interest. However you have misunderstood microsoft's update system.

Updates are a collection of KB's issued as an update. For 5.00 there is only one and that is KB 943858

The other once are hotfixes or stand alone KB's if you will.

You are btw. missing KB 948512 on SQL performance.

Keep up the good work.

Cheers,

Soren

# February 16, 2008 4:19 AM

waldo said:

You are absolutely right on that one, but I was already aware of it.  It just makes life easier.  Talking about Service Packs, Updates, Hotfixes, KB-articles ... it's just too complex.

Actually, I wanted to do it like Update 1.1, Update 1.2 and so on ... Probably, when Update 2 comes out, I'll rename them ;°).

Thanks for the heads-up!

I can't find the hotfix you mentioned, by the way.  Is it a private one?

# February 16, 2008 4:47 PM

waldo said:

I had this issue at a customer of ours. The error message &quot; Login failed for user &#39;sa&#39; because

# February 16, 2008 5:55 PM

mohlabetsi said:

I guess the KB is not publich jet, but it is on the way. I just know it because I have the files and KB here for testing and it finally solves some the the crazy performance issues we have been fighting with since the release of 5.0.

# February 18, 2008 1:25 AM

Don said:

hi just a little question for you....can you tell me what does mean h1 cy2008?...sorry may for the ot...thanks a lot bye

# February 18, 2008 2:38 AM

Zappy said:

I wouldn't say - I still recommend for just adding the options at the end of the string.

The best way is to set it to the End plus about 10 commas.

So not

FIFO,LIFO,Specific,Average,Standard,Waldo

but

FIFO,LIFO,Specific,Average,Standard,,,,,,,,,,,Waldo

The reason is very simple ... merging.

# February 18, 2008 11:07 AM

Natalie said:

Hi Waldo,

there are at least two new ones:

4.0.3.25709 in KB946247

5.0.25344.0 (only SQL) in KB943581

Refer to mbs.microsoft.com/.../KB__NAV.htm to find perhaps even more.

# February 20, 2008 9:00 AM

Chander said:

When you make tables please tell the contents refers to what and please be clear when writing the stuff as some people are not up to your level

# February 22, 2008 5:07 AM

waldo said:

All I can say is that I do my best in being as clear as possible :|.

# February 22, 2008 8:58 AM

waldo said:

Here is the next I-think-up-to-date version of the Service Packs/Updates/hotfixes/Knowledge Base Articles

# February 23, 2008 2:32 PM

Natalie said:

Any problems with tending to help you? ;-)

As you did not seem to know the page with the latest KB article summary yet, you perhaps don't know this one where I took it from, too:

Hot Topics Navision

mbs.microsoft.com/.../navision

The site looked different until February: there were many KB summaries (for each month back to 2006 or 2007). It is a pitty that MS now has erased all former infos :-/

# February 23, 2008 7:39 PM

waldo said:

I love your help!  It makes my blog definitely more valuable Wink.

The site you mentioned is now in my "favorites".  Thanks for that!

# February 24, 2008 2:16 PM

kriki said:

One word on this blog: WOW!!!!!

# February 25, 2008 5:14 PM

waldo said:

Is that an abbreviation or something :)?  For World Of Warcraft?  Or Windows on Windows?

.

.

.

Thanks, Kriki Smile.

# February 25, 2008 5:38 PM

waldo said:

Since a few months now, we have been working on a new initiative in Belgium: the Belgian Dynamics Community

# February 29, 2008 10:28 AM

Adebola Ogunleye said:

Hi,

Please I need someone to help me out urgently.

I have installed SQL Server 2005 and Navision client (sql server option) on my system and I was able to connect to the database, restore data and do all sort.

When I tried connecting from another system, a got an error message cannot find server. I typed the serverpath and name but it still gave me the same thing. Could this be because the systems are in workgroup not domain? Or do I have to set anything on the other systems? (Like the host file when using the native database server). Please help me out

Secondly, I dont know how to bring the stored procedure into SQL, I have already unzipped the xp_ndo.dll file into the binn directory of SQL installation. Can anybody send me the codes on how to do this.

Please, I'll appreciate your urgent response.

Thanking you in anticipation

You can reply back to debby_box@yahoo.co.uk

# February 29, 2008 3:57 PM

waldo said:

I suggest that you open a new thread on Mibuso for that ... then more people will respond ... .

When you copied the xp_ndo in the binn folder, you can add the extended stored procedures by adding them manually on the master database.

# March 1, 2008 3:03 PM

Gaspode said:

Hi Waldo,

Just wanted to say thanks again for this post. I am currently going through some issues with NAV 5.0 SQL 2005, etc. which requires applying some of these updates to try and improve performance.

I know that in order to check if I have applied the correct version I can find the build number (Help, About, Double click on the Version No.) and then Google it to find which update it is. The Google link returns this post. Very useful!

# March 4, 2008 5:26 AM

rappel said:

but from where can i download it, on microsoft they say that there is an update named KB 931841 but they don't give the link!! on this link : mbs.microsoft.com/.../General.aspx{1A824679-0B9B-4BA7-BF5A-C6EB77FC43B3}&NRORIGINALURL=/partnersource/products/navision/newsevents/news/msdynav40_sp3_officevistacompatb.htm?printpage=false&NRCACHEHINT=Guest&printpage=false&wa=wsignin1.0 ... i ca't find the update ...what can i say "i love microsoft"

Plese help

Thanks!

# March 4, 2008 8:02 AM

waldo said:

Are you serious?  I wonder if "live" would give the same results Wink.

# March 4, 2008 8:28 AM

waldo said:

# March 4, 2008 8:29 AM

waldo said:

Recently (last Thursday) I joined the MSDN Evening, organised by Microsoft, to learn more about how to

# March 5, 2008 2:35 PM

Natalie said:

Actually it's no wonder that you've been found in google ... msdynamics.de is not the only community that links to your blog, quite sure ;-)

# March 6, 2008 3:29 PM

waldo said:

On monday, I will be off to Convergence US 2008 in sunny Orlando . I have some mixed feelings about it

# March 8, 2008 4:16 PM

Rashed Amini said:

Have fun at Convergence and looking forward to your blogs.

# March 8, 2008 5:03 PM

waldo said:

Thanks, Rashed.

# March 8, 2008 9:35 PM

Mark Brummel said:

Have fun! And say hi to everyone I know.

/Mark

# March 9, 2008 1:17 PM

David Singleton said:

Have a great time Eric.

i for one will be waiting in anticipation for the high quality blogs that you are now famous for at these events.

Sorry that you are there "alone" this year, and good on you for going.

# March 10, 2008 10:40 AM

waldo said:

It seems that I will not be able to attend many sessions this year. Too many things to do behind the

# March 11, 2008 8:20 PM

DenSter said:

Good stuff Eric, keep it coming! Wish I were there.

# March 11, 2008 8:46 PM

waldo said:

Thanks, Daniel.

By the way, I found the book that Scott recommends: It's the Wrox one: www.wrox.com/.../productCd-0764584979.html

# March 11, 2008 10:40 PM

Bruno said:

A simple way how to handle different Company-Names would realy very much apprichiated. The report should be able to let the user select the company and an sp is generating an dynamic select statement. Anyone has an example how to solve?

C#/VB: Many reports do have attributes on wich you can define the value with an expression. Within this expression, you just can use VB. It took me a long time until i recogniced that my C#-Code ist not valid despite of the framework.

Very good blog by the way!

# March 12, 2008 9:59 AM

waldo said:

Today, it&#39;s not a NAV day at all. Very few NAV sessions - and actually not one where I&#39;m interested

# March 12, 2008 5:35 PM

Tomas said:

I like you lively writting style. It's easy to read in one go even bigger posts.

# March 12, 2008 6:20 PM

waldo said:

Thanks, Bruno.

Now, i'm not an RS specialist.  But be careful of making your stuff dynamical.  You should consider to not making SP's, or SELECT statements dynamics because of the fact that it won't be cached (as also mentioned in the blog)

# March 12, 2008 8:19 PM

David Singleton said:

Eric,

great stuff, keep it coming if possible. Its a pity that your "duties" are keeping you from more sessions, as I would love to read more of your blog posts. It sounds like you have your plate full being there alone.

# March 13, 2008 11:15 AM

waldo said:

Yeah, well, me being here alone has something to do with it :).

# March 13, 2008 5:25 PM

waldo said:

It&#39;s going to be a busy day. Three sessions and quite some work at the booths. I love Michael Rosenorn&#39;s

# March 13, 2008 6:13 PM

Rashed Amini said:

I would like to know if they are going to change it to web service in 6.0.  That way they can get rid of commerce gateway and don't have to use NAS.

It'll make the setup a lot easier.

# March 13, 2008 7:52 PM

waldo said:

Martin Nielander (from the systained engineering team) and Jesper Reabild wanted to give an overview

# March 14, 2008 5:25 PM

waldo said:

This session is presented by Michael DeVoe and Robert Miller. They&#39;re both really good, so I expect

# March 14, 2008 5:25 PM

waldo said:

This session is driven by Chad Aberlen, one of the Microsoft Escalation Engineers. Most of his expertise

# March 14, 2008 5:25 PM

DenSter said:

Those tools must be made available on SQL Server, so we can schedule them without having to install the Job Queue. Can you ask while you're there?

# March 14, 2008 6:17 PM

DenSter said:

I'm willing to think about auto update statistics, I've read a lot of comments saying that it's really not that harmful. However I find the logic flawed to use autostats as well as a routine that manually does it. If auto statistics is so great, then why do we need any tool to update the statistics? Likewise, if you create a tool to update statistics manually, why would you also need to automatically update statistics?

Then I also strongly disagree with having a tool create indexes on SQL Server that don't exist in the NAV table design, I would never recommend that either.

This all sounds very negative, but I am really very happy that they are working on this. It is very good to see though that they are addressing this need, very positive.

# March 14, 2008 6:25 PM

David Singleton said:

[quote user="waldo"]

Keep in mind, if you want to go to the NAV2009 RoleTailored client, you'll have to upgrade to the latest version (5.0 SP1).

[/quote]

This reminds me, I have been trying for about 18 months now to get an answer of whether there will be a Data conversion required for 2009. Have they stated anything yet about that.

# March 14, 2008 6:34 PM

waldo said:

No official confirmation yet.  And if you ask, they say something like "we are indeed really trying to avoid a datamigration".  

Personally, I can understand why they want to keep their options open.  You never know what the future is going to bring... .

# March 14, 2008 7:10 PM

Geert said:

@Waldo: If the future is not yet made at this point (Q2), availability of NAV2009 in Q4/2008 is not an option.

PS: Waldo, thanks for the great job keeping us updated!

# March 15, 2008 6:57 AM

Neuerungen im Service Pack 1 für Microsoft Dynamics NAV 5? » Blog der Microsoft .NET / Dynamics NAV - Group Halle said:

Pingback from  Neuerungen im Service Pack 1 f&uuml;r Microsoft Dynamics NAV 5? &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

# March 16, 2008 11:28 AM

waldo said:

I have some time on the airport to write down some final thoughts of what this Convergence meant to me

# March 17, 2008 9:46 AM

David Singleton said:

Sounds over all like a great event then. I am so glad to hear that it was better than Copenhagen.

I really appreciate reading your blogs, they really do help everyone.

Great work Eric.

# March 17, 2008 11:06 AM

Marq said:

Glad you had a good time, but reading your notes I am happy to have staid home altouhg I would have loved to spend some time with Olga to. :)

# March 17, 2008 11:15 AM

DenSter said:

Excellent series of blogs Eric, thank you very much for taking the time.

# March 17, 2008 12:44 PM

waldo said:

Hm, didn't you read the part "This was by far the most interesting one - as well as personally as professionally" Wink.

Just wanted to point out the good AND the bad.

# March 17, 2008 12:49 PM

Seb said:

Thanks for all the info Eric

# March 17, 2008 2:48 PM

Alex Chow said:

Great blog! It's almost as if I'm there, but not really.

# March 17, 2008 6:14 PM

waldo said:

Thanks for the comments, guys Smile.

# March 18, 2008 12:20 PM

Jörg A. Stryk said:

Funny, these "Performance Optimization Tools" grow like mushrooms ;c)

Is it also "free-of-charge" - as my "NAV/SQL Performance Toolbox"?

# March 19, 2008 10:37 AM

waldo said:

It is free of charge for partners.  And they were looking into it for making it available for customers via customer source as well ... but couldn't confirm if this was possible or not.

# March 19, 2008 10:46 AM

Ola Hallengren said:

>This sounds cool, but really ... I want to do this from within SQL Server, not from within NAV

>The next tool, SQL Index Defragmentation Tool, works with the sys.dm_db_index_physical_stats DMV. You use this to defragment indexes, which can have a noticeable impact on performance.

I would like to share a solution for doing dynamic index optimization, with the Navision community. It's a stored procedure that does index rebuild online or offline, index reorganization, statistics update, index reorganization and statistics update or nothing based on fragmentation level and LOB existence. It's using sys.dm_db_index_physical_stats just as the SQL Index Defragmentation Tool.

blog.ola.hallengren.com/.../3440068.html

blog.ola.hallengren.com/.../Documentation.html

This reduces the time it takes to do index maintenance considerable. It also reduces the sizes of your transaction log backups during the index maintenance.

The solution has been very thoroughly tested and it has been running on a large Navision installation for about 6 months.

Ola Hallengren

http://ola.hallengren.com

# March 19, 2008 7:03 PM

Erik P. Ernst said:

How do you see these tools as compared to the other "tools" available for SQL performance optimization? I am here thinking about the ones from SQL Perform and the other companies specializing in this.

# March 19, 2008 7:06 PM

waldo said:

Ola, thanks for sharing!

Eric, I would still go for the SQLPerform solution myself for the reasons I mentioned above.  It's a maintenance tool, but it still needs some work for sure... .

# March 20, 2008 8:59 AM

waldo said:

As promised, 5.0 SP1 W1 is available for download . Versions W1 (WorldWide), DK (Danish), DE (German

# March 28, 2008 3:24 PM

David Singleton said:

Just a pity they release it just before they take the site down for maintenance. Did anyone manage get it before they took partner source down?

[quote]Our Apologies

From Friday March 28th, 2008 at 6:00pm to Monday, March 31, 2008 at 2:00am CST (GMT -6:00), VOICE, PartnerSource, CustomerSource and Commerce (NBE), CLT systems will be unavailable as they will be down for maintenance. [/quote]

# March 30, 2008 1:30 AM

David Singleton said:

I see the new Microsoft Web site just came on line, so I guess this is why partner source was down. Hopefully we get a new version tomorrow (of partner source I mean).

# March 30, 2008 1:11 PM

waldo said:

I did see the pages on partnersource,  but I was at a customer, so I didn't download it yet.  Now, PS is off line ... .  Too bad indeed.

# March 30, 2008 2:31 PM

ServicePack 1 für Microsoft Dynamics NAV 5 verfügbar » Blog der Microsoft .NET / Dynamics NAV - Group Halle said:

Pingback from  ServicePack 1 f&uuml;r Microsoft Dynamics NAV 5 verf&uuml;gbar &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

# March 30, 2008 3:22 PM

waldo said:

I just couldn&#39;t resist posting these links: The Waldo Ultimatum: www.youtube.com/watch

# March 30, 2008 9:22 PM

DenSter said:

He doesn't remember who he is because he left his passport in Mexico :) Stay tuned for the sequal 'The Revenge of MexiWaldo'

# March 31, 2008 3:13 AM

waldo said:

LOL.

Actually, the problem was just the opposite.  I knew who I was, but couldn't proove it - and they DID catch me there :|

# March 31, 2008 3:10 PM

Nikolas said:

Not that i have a slow connection but has anyone noticed that it can be quite painful to get into PartnerSource...

# March 31, 2008 5:56 PM

David Singleton said:

It was down all weekend, so all the people (like me) that do all their downloading over the weekend had to catch up on Monday, so it was just under heavy load. It seems to be ticking along nicely now though.

# April 1, 2008 9:59 AM

David Singleton said:

The Waldo Ultimatum is great. Obviously someone with too much time on their hands but definitely fun.

PS I forgot my Passport at Disney after Directions, so you are not the only one. Ended out stranded in NY till they found it. But not anywhere near as much fun as your Mexico story.

# April 1, 2008 10:06 AM

Gaspode said:

Thanks again Waldo. Every time I need to get to the 5.0 SP1 download page, I know the easiest way to get to it is via your blog. Much easier than searching on PartnerSource.

# April 1, 2008 11:42 PM

waldo said:

Yesterday, I got the message that my MVP-title has been &quot;renewed&quot;. I must be doing something

# April 2, 2008 10:53 AM

Marq said:

Thanks.

Congrat's to and keep those blog's comming...

# April 2, 2008 10:53 AM

waldo said:

I sure will :-)

# April 2, 2008 11:05 AM

Nuno Maia said:

Keep good work

# April 2, 2008 11:06 AM

kriki said:

Congratulations both of you!

And keep the blogs coming!!!!

# April 2, 2008 3:33 PM

Romeo said:

congratulations !!!!

# April 2, 2008 4:57 PM

David Singleton said:

Well done.

# April 2, 2008 5:26 PM

DenSter said:

Excellent news Eric, well deserved, congratulations!

# April 2, 2008 10:30 PM

waldo said:

Thanks for the kind words, guys. Smile

# April 2, 2008 11:05 PM

Gaspode said:

Well done Waldo. You fully deserve it.

Cheers, Dave.

# April 2, 2008 11:10 PM

Sascha Heller said:

Sorry for being a newbie at this, but what do you mean by "Runtime Upgrade to Vista-supported clients"?

# April 3, 2008 5:58 AM

waldo said:

Well, that's actually an upgrade of only the client.  The functionality stays the same.  I actually comes down to using a new version of the fin.exe or finsql.exe .

# April 3, 2008 11:07 AM

Sascha Heller said:

I was told today by our Solution Center and have since verified for myself, that NAV 4.0 SP1 seems to work just fine on Windows Vista - so long as you're connecting to a C/SIDE database (if you connect to a SQL database, it bombs out).

# April 3, 2008 5:12 PM

Alex Chow said:

Congrats! Keep those blog posts coming!

# April 3, 2008 7:19 PM

Erik P. Ernst said:

Congratulation Eric, that was deserved...

# April 4, 2008 10:27 AM

Waldo's Blog
Microsoft Dynamics NAV
said:

Finally found some time to write Part II of this topic. The first part was quite a popular post, if I

# April 4, 2008 11:52 AM

waldo said:

Finally found some time to write Part II of this topic. The first part was quite a popular post, if I

# April 4, 2008 12:09 PM

DenSter said:

There's a reason why some people are MVP's :) another great blog Eric

# April 4, 2008 2:24 PM

Seb said:

Thanks for the time you took to provide us with this great info!

# April 4, 2008 6:03 PM

Kurt Juvyns said:

Hi Eric,

Congratulations with your updated status.

Another year of blogging. I'm looking forward to your blogs on the EMEA direction sessions you will host ;-)

# April 10, 2008 10:20 PM

waldo said:

Well .. I will not be blogging my own session, off course Wink.  Maybe afterwards, I will make a blog of the contents ... but that's a big "maybe".

# April 11, 2008 8:02 AM

waldo said:

It has been a while. Not much has changed, just the SP1 is now officially released (but I already added

# April 11, 2008 8:58 AM

pdj said:

Yet another great entry in your blog. Just sad this overview isn't available directly on PartnerSource :-(

I would suggest you added some similar links for SQL updates:

support.microsoft.com/.../913089

support.microsoft.com/.../LN

# April 11, 2008 9:56 AM

wito said:

great Blog wWaldo,

i was wondering about the following KB's if they are missing in the summary:

936719

940043

945992

945339

See also:

premier.microsoft.com/default.aspx

# April 11, 2008 2:03 PM

waldo said:

You were right .. I added the two new ones.

Thanks, man!

# April 12, 2008 2:31 PM

pdj said:

The links to the 1.4 and 1.5 updates are to the premier site which not all partners have access to. (At least I don't :-()

However; if you just take one of the other links to PartnerSource you can replace the kb no. and the links works fine.

# April 13, 2008 10:15 AM

waldo said:

Thanks pdj.  I updated the links... .

You get access to premier when you get a PABS (Partner Advantage Business Solutions) contract with Microsoft.  We have it, and it is linked to the same passport as the one I log into partnersource.  So I didn't notice it :|.

# April 13, 2008 10:46 AM

Natalie said:

Have a look at this - you won't believe it:

mbs.microsoft.com/.../KBDisplay.aspx

# April 14, 2008 8:39 AM

waldo said:

Big Smile.

Seems my overview is becoming less useful ... or in other word(s): useless Sad.

Still, it's behind the "passport", so it'll not show up in google or anything.  I'll still add it on my blog until they make it more public Smile.

Thanks, Natalie.

# April 14, 2008 8:54 AM

Natalie said:

Nah Waldo,

you're noncompetitive - they do not keep it up to date like you do :-)

# April 14, 2008 6:30 PM

pdj said:

Your page is WAY better! More frequent updates. More hotfixes. Links to base versions.

I just noticed that Partnersource now offers a few "public" RSS-feeds, but they are also not up-to-date. Nice work Microsoft :-(

Check it at mbs.microsoft.com/.../rssfeeds

In short: Keep up the good and valuable work Waldo, it is much appreciated :-)

# April 15, 2008 10:15 AM

waldo said:

:) OK, I'll go through with it Wink.

# April 15, 2008 11:02 AM

wito said:

Thanks Waldo, for updating the List. Your List has a better overview!

If found another one for 40SP3:

KB 948302

see KB 931638 for a list of 40 (maybe there are more updates in that list for 4.0XX)

# April 16, 2008 1:56 PM

kriki said:

You shouldn't even have thought about stopping with it!

# April 18, 2008 11:38 AM

Kine said:

New hotfix update (not included even on the official site):

Build 26410

KB 950920 (not published yet)

Type: Standalone files for client and NAS.

# April 18, 2008 12:47 PM

waldo said:

It seems that I&#39;m not going to blog this directions. It&#39;s a bit akward for me, being able to

# April 18, 2008 2:07 PM

Kriki’s blog » Moving from native C/SIDE to SQL by Mark Brummel said:

Pingback from  Kriki&#8217;s blog &raquo; Moving from native C/SIDE to SQL by Mark Brummel

# April 18, 2008 2:12 PM

David Singleton said:

Well he has some big shoes to fill, but I am sure he can reach your standards. I look forward to seeing this.

# April 18, 2008 3:37 PM

waldo said:

I hadn&#39;t put this on my blog yet, but people asked me to give a presentation about Hardware on Directions

# April 19, 2008 9:39 PM

Tvis said:

What format is this presentation in? It contains a lot of xml files but no .ppt or am i missing something?

# April 20, 2008 10:34 AM

girish.joshi said:

Great presentation, Waldo.  It's amazing to see all of this information collected in one place.

Can I ask you what your hardware recommendations are for the tempDB?

In this thread (dynamicsuser.net/.../114694.aspx)

David had the idea to put it on its own RAID 1 for large databases.

# April 21, 2008 3:18 AM

girish.joshi said:

The format is in powerpoint 2007.  You can download a compatibility pack here:

www.microsoft.com/.../details.aspx

# April 21, 2008 3:19 AM

waldo said:

Definitely for big databases, I would put it on a seperate RAID 1 as well.  In SQL2005, it seems that the tempdb is used more then 2000...

# April 21, 2008 8:52 AM

Gerdien said:

I have got good feedback on your session. It were busy days for me, so I missed the time to say hello to you and thank you ....

# April 21, 2008 10:38 AM

waldo said:

Thanks, Gerdien.  And also thanks for the perfect organisation!

# April 21, 2008 10:58 AM

waldo said:

Working on a new update again.  Will be published soon enough.

Thanks for the heads up, Guys!

And wito - it was nice meeting you :-)

# April 21, 2008 2:35 PM

Erik P. Ernst said:

I think it's a shame you didn't blog here! I remember from some of the other conferences it has been very interesting to see the different bloggers different views on the same sessions...

And then of cause, I also find it a shame that the users here on http://dynamicsuser.net will not see the blogs from Directions...

# April 21, 2008 11:25 PM

waldo said:

I am writing the &quot;final thoughts&quot;-posts because it seems interesting for me to have somebody&#39;s

# April 22, 2008 12:48 AM

Kine said:

Pitty that I missed this one. I hope that next year... ;-) but there is so many events and I cannot be everywhere...

# April 22, 2008 7:11 AM

QQ said:

oooh, so that's what waldo looks like :p

# April 22, 2008 7:16 AM

waldo said:

@Kine:

I know ... that's what my worry is as well.  I'm skipping WPC.

@QQ:

I read your post on mibuso as well.  Who the hell were you, man Wink?

# April 22, 2008 9:16 AM

waldo said:

Embarrassed

OK ... don't know how to react here...

Indifferent

# April 22, 2008 9:17 AM

Mark Brummel said:

Great post Eric, we had a great time again.

See you thursday.

# April 22, 2008 9:38 AM

kriki said:

I can find some reasons why you were so calm during your presentation:

1) Good preparation.

2) You knew very well what you were talking about. It was not something you learned and just reproduced, but something "you lived"!

# April 22, 2008 5:46 PM

waldo said:

I wanted to wait until I received some pictures, but I won&#39;t. I&#39;m a little bit too excited about

# April 26, 2008 2:48 PM

Claus Lundstrøm said:

Great event and kudos for bringing this together. Let me know you if you in the future need any help from the NAV Core team and I will be happy to help you out.

# April 26, 2008 9:56 PM

Daniel Ekvall said:

Seems to be a new 4.0 version out:

4.0.3.26410 (from KB 950920).

Also, the build of NAV 5SP1 is 5.0.26084.0.

Thanks

Daniel

# April 26, 2008 11:37 PM

waldo said:

we'll sure do!  And thanks again, Claus!

# April 27, 2008 11:50 AM

waldo said:

Yep, indeed.

I'm already working on a new table and will publish it soon.

I have some new interesting links as well that I would like to share.

Thanks for the heads up!

# April 27, 2008 11:55 AM

Burim Avdiu said:

I can't work in Navision 4.0 sp3 with Vista Sp1

# April 29, 2008 4:29 PM

waldo said:

What build?

# April 29, 2008 5:08 PM

waldo said:

In a conference like Direcionts EMEA , I noticed again how interested people can be in sometimes such

# May 1, 2008 2:39 PM

thaug said:

Do you have a text file of the object that you could share?

# May 1, 2008 3:57 PM

David Singleton said:

Yes Eric, this is a nice simple and neat solution to a very commonly requested issue.

Thanks for sharing it.

# May 2, 2008 3:44 AM

DenSter said:

I've already sent a link to this blog to customers :)

# May 2, 2008 2:57 PM

waldo said:

:)

o-ow, I hope they like it Wink.

# May 4, 2008 12:20 PM

waldo said:

@thaugh

I have no .txt available.  If you just follow the description, it won't take long, I guess... (I hope).

# May 4, 2008 1:51 PM

Fommo said:

Great tip. So simple and yet so useful. It's funny how often the best solutions are the simplest.

Thanks again!

I'll start using it with all my customers from now on!

# May 5, 2008 10:24 PM

waldo said:

Smile

Great!

# May 6, 2008 9:21 AM

Roel said:

Hey Waldo! Thanks for the event. Me and the guys (aka Same Same But Different) had great fun playing at the beautiful location! :-)

Keep up the good work!

/Roel

# May 6, 2008 12:14 PM

Nuno Maia said:

Great tip

# May 6, 2008 9:48 PM

James Crowter said:

The best solutions are simplest - this is really neat and really useful - thanks a lot

# May 7, 2008 1:15 AM

Viktoras said:

Hi Waldo,

There is one more important hotfix for 4.0 - KB 950920, build 26410.

Cheers,

Viktoras

# May 8, 2008 6:45 AM

Gaspode said:

I love this tip and have been playing about with it. I've added a couple of extra features and I'll post something about it when it's done, but I have a question. Is there any way of stopping someone from clicking on the form and pressing ESC which then closes it? Other than setting Close Forms on Esc to No. I tried putting EXIT(FALSE) in the  or putting something in the OnQueryCloseForm() but that is BAAAAD and you can't exit the company or NAV. Any ideas?

# May 8, 2008 7:13 AM

waldo said:

Thanks.  I already added it to my (new) list.  Seems like I have to update it asap.  Will do it as soon as I sorted out something with Microsoft... .

Thanks for the heads up!

# May 8, 2008 8:40 AM

waldo said:

Thanks, Guys!

@Gaspode:  I have been strugling with that myself and I don't see a solution (yet).  The only way (for now) is to change the option "Close Forms On Esc" to "No".  

But honestly, we don't do that.

# May 8, 2008 8:43 AM

Jörg A. Stryk said:

Here we go:

Build 4.0.3.26170

mbs.microsoft.com/.../KBDisplay.aspx;en-us;949866">mbs.microsoft.com/.../KBDisplay.aspx

Build 4.0.3.26565

mbs.microsoft.com/.../KBDisplay.aspx$en-us$952355&wa=wsignin1.0

# May 9, 2008 9:43 AM

Viktoras said:

I found one more blog with hotfix information:

blogs.technet.com/gediminb

# May 9, 2008 10:06 AM

Gaspode said:

Hi it's me again. OK so I had a go at doing some things with this idea. If you're interested, take a look at my post on gaspodethewonderdog.blogspot.com/.../where-am-i.html

I did come across a few issues so maybe some of the clever readers of your blog could answer the bits that don't work. Thanks for the inspiration and thanks heaps for posting the idea. Cheers, Dave.

# May 9, 2008 12:21 PM

waldo said:

The updates keep on coming ... so we keep updating. If it continues with this tempo, we&#39;ll have quite

# May 9, 2008 1:59 PM

Natalie said:

Hi Eric,

you should bookmark this one:

mbs.microsoft.com/.../microsoftdynamicsnavsupportnorthamerica.htm

The majority is also useful for non-NAs and represents a great part of the partnersource link list that I have showed you earlier.

# May 9, 2008 5:40 PM

waldo said:

wow ... that's an interesting site, indeed.

Going to add it in the next update.

thanks!

# May 10, 2008 12:21 PM

Gaspode said:

Hey thanks Waldo, I was wondering where I should send feedback.

# May 17, 2008 12:04 AM

waldo said:

I was just re-reading my post, and should make something clear.  With "...but tell them how bad it is", I don't mean that I find it bad, but that you should send the comments on how it can be approved ... not comments like "hey, I like the fast bands" or whatever!

Personally, I like a lot about the new client, and everything about the new integration possibilities.  So no complaints here ... .

Smile

# May 18, 2008 1:07 PM

waldo said:

On the 15th of May, we had our first &quot;real&quot; information evening organised by the Belgian Dynamics

# May 18, 2008 2:24 PM

wito said:

Hi Waldo,

while i was checking the updates that i had to download for the 5.0 release i noticed something in the list. I consider the Build No. to be leading in the above list. KB943581 is before Update 1 and has Update 0.1 as prerequisite. KB945339 has Build No. 25560 (directly after Update 1?).

I also found a new one KB948512 (Build No. 26026)

# May 20, 2008 4:59 PM

waldo said:

Well, build No. is indeed "leading".  

I didn't know the build no. of KB945339 (therefore the question marks). If the build is 25560, indeed, it should be rearranged in the table.

KB945339 is very badly explained in the article as well.  No prereqiusites defined, later build than update 1, only a finsql.exe ... so it's doomed to fail.  

I'm pretty sure it is going to need the update 1.

thanks for the info.  i'm going to update my table and put a new one online asap.

# May 20, 2008 10:18 PM

wito said:

Hi Waldo,

it's me again! I wrote about different KB numbers!

KB943581 is before Update 1 (< build no.) and has Update 0.1 as prerequisite in the description.

KB945339 is after Update 1. See the SYMPTOMS section in the KB description:

You run one of the following products:

• Microsoft Dynamics NAV 5.0 with Update 1 installed  

• Microsoft Dynamics NAV 4.0 with Update 6 installed

Thanks to Nathalie i found out that you can download NAVXX40SP3 including Update 6 (KB940718)!

Thanks Nathalie!

And thank you Waldo for publishing this list!

# May 21, 2008 10:21 AM

waldo said:

You are 100%, absolutely, entirely correct. Smile

I already updated my table and it seems I have to publish it asap Wink.

By the way, I'm not a big fan of update 6 - the "locking during error message" makes me not want to use and recommend it. From 6.2 this is solved... .

# May 21, 2008 10:40 AM

Jeff said:

Hi does it work in acitrix environment running on w2003 servers ?

thx

Jeff

# May 21, 2008 12:29 PM

waldo said:

Yes, that should work...

# May 21, 2008 1:11 PM

waldo said:

Natalie pointed my attention to the link of the North American Support team. I have &quot;stolen&quot;

# May 21, 2008 3:50 PM

Natalie said:

Have a nice holiday - you deserve it! :-)

# May 21, 2008 6:59 PM

wito said:

Waldo,

first i want to wish you a very nice holiday. Enjoy it!

KB943581 has Update 0.1 as prerequisite in the description. See the Symptoms section:

You apply hotfix 936885

...

IF you use the download link 4.0 SP3 from the above table:

See the Announcement section:

29 FEB 2008 The local downloads on this page has been updated with Platform Update for Microsoft Dynamics NAV 4.0 SP3 KB 940718

So if you download 4.0 SP3 from Partner Source you now have the one with Build No. 25143!! I think the link to 4.0 SP3 has to be in front of Update 6 now?

# May 22, 2008 10:37 AM

waldo said:

Thanks wito.

I updated the table in this post (again).  Sorry for this, folks.

They're not making it easy on me Sad.

I think I'm going to remove Update 1 to 6 in the next update.

# May 22, 2008 11:25 AM

Philippe said:

I'm not agree with you about RAID 5. The best practices on SQL Server 2005, for max performance, (source MCS France) are RAID 5 for data, RAID 0+1 for log, RAID 1 for tempdb.

# May 22, 2008 11:59 PM

Microsoft Dynamics NAV Team Blog said:

Last month (23 rd – 25 th April), Claus Lundstrøm and I took to the road and drove all the way from Vedbæk

# May 23, 2008 1:30 PM

waldo said:

Hm... you're not going to find a discussion here, I'm afraid.  But feel free to discuss this on mibuso to get another one's opinion.

You could go for RAID5 for data (mainly used for reading), but I would never do that.  I don't want a write queue ... not even (and definitely not) for the data disks.

But again, feel free for opening a thread on mibuso or dynamicsuser... Smile.

# May 23, 2008 2:57 PM

navision Patch said:

Dear All,

I m using Vista on my system and want to run navision 4.0 Sp3. so can anybody help me out how do i run it.

# May 26, 2008 10:32 AM

Waldo's Blog
Microsoft Dynamics NAV
said:

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

# June 9, 2008 8:25 AM

Waldo's Blog
Microsoft Dynamics NAV
said:

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

# June 9, 2008 8:25 AM

waldo said:

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

# June 9, 2008 9:22 AM

John said:

Is it possible to run the client without having to elevate the permission level to local administrator ie selecting "run as administrator"?  I don't want to give users administrator level access to their machines.

John

# June 12, 2008 1:50 PM

waldo said:

Because I&#39;m a Belgian, and Belgium is in group 2, I&#39;m a bit more excited about the Group 2 releases

# June 17, 2008 11:44 AM

Kine said:

Yup!!!

It is what I forgot today - check the Patnersource if the version is already released!

Thanks for the info...

# June 17, 2008 6:22 PM

waldo said:

Glad I could be of your assistance Smile.

# June 18, 2008 11:56 AM

waldo said:

I found following information on partnersource and I found it worthwile to put it online. I didn&#39;t

# June 18, 2008 12:17 PM

fvanrooy said:

Woohoo...sounds more like new pain in the...

Better watch out for paintballs...rrr

Thx and grtz!

# June 18, 2008 12:27 PM

Timo said:

Hi,

I am not quite sure, but with this code you will face at least one additional problem:

You start looping through 2800 records, mark every second one, and the you loop again through the marked 1400 records.

But if you loop through a recordset with more than 500 records, FINDSET is the worst idea to use, because SQL has to fetch x times 500 records (in your case, 6 and 3 times 500 records), which makes performance really bad. Microsoft strongly recommends to  use FINDSET only with less than 500 records in the recordset, so that SQL does only perform ONE single SELCT TOP 500 command.

In recent Microsoft statements, FINDSET (with or without parameters) is regarded as being slow, unforeseeable and problematic due to strange locking behaviour.

Try FIND('-') instead, which is recommeded for loops with more than 500 records, and your performance should increase. Maybe the marks are not the problem at all...

# June 18, 2008 3:28 PM

waldo said:

Hm, I don't agree.

As you can read in mij first post (dynamicsuser.net/.../what-impact-does-my-c-al-have-on-sql.aspx), I had to conclude that it is safe to be using FINDSET at all times.

Can you point us to the documents, websites, stuff where microsoft recommends this?

# June 18, 2008 3:56 PM

Timo said:

Here some links:

www.mibuso.com/.../viewtopic.php

(advantage of find('-') compared to findset)

And an exercpt from the Microsoft resource kit:

"When you use FINDSET without any parameters it functions as a firehose and fetches

around 500 records. If you want to retrieve more than 500 records, you can still use

the FIND('-') function. Alternatively, you can use FINDSET(True).

If you need less than 500 records, use LOCKTABLE and then FINDSET."

Locking Poblems with Findset (there are additional articles available, I think):

blogs.msdn.com/.../Default.aspx

(search for FINDSET and read the following comment regarding locking problems)

This is, why I won't use FINDSET anymore. In some of  our projects, we had performance problems and even deadlocks due to FINDSET, because it locks more than the filtered records. With FIND('-'), everything worked fine and fast.

But this might also depend on the case, of course ;-)

# June 18, 2008 5:33 PM

waldo said:

Sorry, dude, but I still have big doubts on this.  I did my own tests (as you can read in my post (URL above)), and the results were quite clear.

When marking records, it just doesn't matter.  Probably it'll loop in cache.  And still, if not in cache, it does a seperate SELECT for every record.  No SELECT TOP 500 at all (because there is no filter, there is no WHERE-clause).

Furthermore, if just looping (not marking), I did my tests, and (als Stryk also mentions in the link you sent me) it does client side cursoring for the first 500 records.  That's why (when looping more then 500 records) you first get a SELECT TOP 500, and immediately after that a SELECT * (it looped the first 500, noticed there were more, and therefore getting the rest of te records the same way as FIND('-') did).

That's what is clearly shown in the client monitor and SQL Profiler.

But let's be sure.  We are interested in what is fastest.  I'll try to think of a scenario tomorrow to test this out in a big database... . Hope to find some clear results on this... .

# June 19, 2008 12:32 AM

Timo said:

Ok, I agree with you (and your test results), which are a very good work. But does it reflect the multi-user environment, which we try to optimize in our projects?

Imagine a company, typing in orders every minute and an automatic sales reservations for all items. FINDSET is fast, agreed - in a single-user environment! But with the unpredictable locking system, in a multi-user environment, I would not bet on FINDSET but on FIND('-'). I had two projects, where I could prove this behavior. FINDSET loses all performance advantages due to its locking problems.

I cannot prove this with a comparison in microseconds - but all deadlocks and waiting periods were gone at the time I replaced FINDSET.

Your idea to use a larger database is good, but maybe you should also try to build up a test scenario in multi-user style ;-) Because fast is only, what is fast in single- AND multi-user environments. It doesn't help our customers if a single user is able to work fast, and 10 users suffer from performance.

But you are right, in single-user scenarios, FINDSET should win the contest...

# June 19, 2008 2:09 PM

David Singleton said:

Hey thats very useful info thanks.

Whilst it is always implied that a Service Pack upgrade does NOT require a data upgrade, its good to see them specifically confirm this with this version.

# June 19, 2008 5:52 PM

waldo said:

I will try to think of a way to simulate what you mean, but it's nog going to be easy though... .

# June 20, 2008 8:23 AM

pdj said:

New update for NAV5SP1: mbs.microsoft.com/.../KBDisplay.aspx$en-us$954191&wa=wsignin1.0

# June 29, 2008 12:10 AM

waldo said:

Here is a new update of &quot;THE&quot; list . Enjoy! Released Version Update Build No. KB number Prerequisites

# June 30, 2008 1:35 PM

wito said:

Hi Waldo,

its me again. Did you had a good vacation?

Look at (for 50SP1)blogs.technet.com/.../microsoft-dynamics-nav-5-0-sp1-latest-available-version-build.aspx

:

Microsoft Dynamics NAV 5.0 SP1 build 26084.

Current available fixes:

5/29/2008. KB 953245; build 26654. Cfront folder. "C/Front hangs while generating a lot of temp files "

6/11/2008. KB 952373; build 26751. Client folder. "Selecting specific Printer Tray does not always work"

6/26/2008. KB 951631; build 26751. Client folder. "NAV 5.0 SP1 locking error when you print a report that calls code in a form"

6/30/2008. KB 953545; build 26751. Client folder. "Local variable values not updated in debugger"

6/26/2008. KB 954342; build 26810. Client folder. "NAV shows unexpected results when filtering, and may crash "

and for 40SP3:

blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-4-0-service-pack-3.aspx

# July 2, 2008 11:18 AM

waldo said:

Thanks, wito.  When I was checking them out, I couldn't open the KB articles, zo I guess they're not public yet... .  I will update them when they come available.

# July 2, 2008 2:12 PM

waldo said:

Finally, there is some (good) documentation available regarding the local functionality of NAV. For a

# July 7, 2008 12:05 AM

AMD Talk » Microsoft Dynamics NAV 5.0 Local Functionality said:

Pingback from  AMD Talk &raquo; Microsoft Dynamics NAV 5.0 Local Functionality

# July 7, 2008 3:11 AM

Pregnant Man » Microsoft Dynamics NAV 5.0 Local Functionality said:

Pingback from  Pregnant Man &raquo; Microsoft Dynamics NAV 5.0 Local Functionality

# July 7, 2008 4:53 AM

Kine said:

I know that they told us that they are working on this documentation one year ago. I am happy that they finished it and now we have it available. Good for all of us who are working with international projects etc.

# July 7, 2008 6:38 AM

David Singleton said:

Famulos news, I have only been waiting 17 years for this.

Thanks Eric for the links.

# July 8, 2008 11:06 AM

waldo said:

I agree ... it was worth sharing it :)

# July 9, 2008 8:08 AM

Kine said:

But still, some countries are missing, like Czech Republic... it seems like GR1 and may be some other countries are on the list...

# July 14, 2008 8:31 PM

waldo said:

Belgium is on the list, and that's group 2.

I understood it's a local "initiative", so you should wake up the Czech Microsoft People ;°)

# July 14, 2008 9:50 PM

binto0002 said:

thank you very much! This is my searching for my job! But I can not download from UK???!

# July 17, 2008 10:19 AM

waldo said:

How do you mean?

# July 17, 2008 10:34 AM

waldo said:

I was asked by MSDynamicsWorld.com to write a small piece about NAV2009. Not easy to do, because as MVP

# July 18, 2008 1:12 PM

windows server raid 1 or raid 5 performance sql said:

Pingback from  windows server raid 1 or raid 5 performance sql

# July 21, 2008 1:17 AM

Про Navision, Алексей Финогенов said:

... Нашел интересную информацию опубликованную Waldo в своем блоге dynamicsuser.net/.../microsoft-dynamics-nav-2009-what-s-to-expect.aspx

# July 21, 2008 8:38 AM

waldo said:

For you information:

the number of descriptions have been extended.  You can find everything here:

mbs.microsoft.com/.../MSDNAVlocalfunct

# July 24, 2008 2:02 PM

Bookmarks about Microsoft said:

Pingback from  Bookmarks about Microsoft

# July 27, 2008 1:30 PM

waldo said:

As you might have noticed, I changed the table a little bit. I think it&#39;s far more useful to see

# July 28, 2008 1:39 PM

GB said:

after installing the client folder Im still getting

error"programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!" what else do i need todo

# July 29, 2008 4:56 PM

waldo said:

Normally, I would have done an article about Sumindexfields on versions previous to 5.0 SP1, but I decided

# August 1, 2008 2:12 PM

Bjarne Astrup said:

$Cnt is used internal by the SQL Server to find out when the record can be removed from the indexed view again.

# August 1, 2008 4:53 PM

Tarek Demiati said:

When is scheduled the next event ?

BTW : Do you accept French in your Belgian gathering ? ;-)

# August 1, 2008 5:41 PM

Tarek Demiati / Sun Softworks said:

I was there, unfortunatly the only person I recognized and had a chance to say hello and talk to was Hynek (he was one of my Navision trainer in the UK back in 1997) and Jorg.

I've recollection having seen Luc, Eric & Mark but back then I did not have a picture to put against the names, so next time I will say hello :-)

# August 1, 2008 5:52 PM

David Singleton said:

Hey well done Eric,

There is a ton of info out there about Indexed views, but you have done a great job of finding the important stuff, and summarizing it all in one place.

PS I wish you a fast recovery on the knee.

# August 2, 2008 3:01 PM

waldo said:

@Bjarne: Ok, thx.  Does this mean that every indexed view has a $Cnt-field?

@David: Thanks, David.  Also for the knee.  It's something I'm not looking forward too.  In 9 months, I will be able to play basketball again ... Sad.  Not really a 'fast recovery', is it?

# August 3, 2008 1:16 PM

waldo said:

Going to Directions US?

# August 3, 2008 1:26 PM

waldo said:

Off Course!

If there are french-speaking people, we just do the presentation in English.

Just check www.dynamicscom.be to check for next events...

# August 3, 2008 1:28 PM

Bjarne Astrup said:

Only if the view definition uses an aggregate function or GROUP BY, the SELECT must include COUNT_BIG(*). The name of the column is no matter. Here it's called $Cnt but you can call the column what you want.

# August 3, 2008 3:06 PM

waldo said:

Good to know: there is a platform update available for 5.0SP1.  More info here:

mbs.microsoft.com/.../KBDisplay.aspx

# August 6, 2008 3:33 PM

tori7 said:

Why is it when I try to open the doco file above I get a http403 and says website requires me to log in.

# August 6, 2008 6:53 PM

waldo said:

I guess because you need to log into partnersource (first).  This is problably more useful:

mbs.microsoft.com/.../MSDNAVlocalfunct

# August 6, 2008 7:01 PM

awarnica said:

Hi,

When I do this, my shapes seem to be on top of the textboxes (so I cannot see the text) - I know I am missing something simple...

# August 11, 2008 5:09 PM

awarnica said:

Hi,

You need to add the shapes first - then the labels afterwards, and then the labels will appear on top of the shapes instead of being hidden :)

# August 11, 2008 7:03 PM

waldo said:

Smile

Thanks for posting the answer.  I was going to try this out ... but you were too quickly.

# August 12, 2008 8:51 AM

girish.joshi said:

Just a suggestion, but do you think you might be able to display this table in reverse (newest release first) order?

# August 12, 2008 3:44 PM

waldo said:

Hm, that makes sense ... let me think this over.

Thanks for the suggestion!! Smile

# August 12, 2008 4:15 PM

Wito said:

Hej Waldo, great work again!

check this link for updates on 40SP3 (KB952873, 953313, 929047?, 954342, 954722):

blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-4-0-service-pack-3.aspx

# August 13, 2008 1:36 PM

Viktoras said:

Hi,

I have solution which allows to have information form always opened.

Idea is following - form should be allowed to close, because otherwise Navision can't be closed. But when form is closed, Navision timer is activated, which after some time (I use 100 milliseconds) opens the form back and deactivates timer.

I've created single instance codeunit (GeneralInformationMgt) with following code:

OnRun()

CLEAR(NTimer);

CREATE(NTimer);

NTimer.Interval(100);

OpenForm;

FormClosed()

NTimer.Enabled(TRUE);

OpenForm()

NTimer.Enabled(FALSE);

FORM.RUN(FORM::"General Information");

NTimer::Timer(Milliseconds : Integer)

OpenForm;

Here FormClosed and OpenForm are functions with no parameters; NTimer is global variable, Navision Timer automation.

On form's OnCloseForm trigger function GeneralInformationMgt.FormClosed is called.

From codeunit 1 I run GeneralInformationMgt codeunit instead of opening information form.

Hope my explanation is clear enough.

# August 13, 2008 5:53 PM

Viktoras said:

awarnica, you can use Fromat -> Bring to Front / Send to Back functions on controls.

# August 13, 2008 5:57 PM

Gaspode said:

That is fantastic Viktoas!

I have implemented your suggestion on my Where Am I tool and it works a treat. I just need to package it up with some instructions and pop it on the downloads page!

Thanks for sharing this and leaving the comment on my blog to let me know you had done it.

Cheers,

Dave.

# August 14, 2008 3:12 AM

Gaspode said:

Hi Waldo,

I've been trying to contact you by various means - I sent an e-mail to your Dynamics User account, I tried an e-mail to question on your MSDynamicsWorld.com article and I tried a private message to your Dynamics User account - all with no luck. This my final last ditch attempt. If you get this could you please send me a private message through this forum?

Thanks, Dave.

# August 14, 2008 3:45 AM

waldo said:

Contacted Smile.

# August 14, 2008 2:10 PM

waldo said:

A new way to get familiar with the product ... and not a bad one. A few months ago, we could read about

# August 14, 2008 2:34 PM

waldo said:

That's a good reference, thanks!  I will add it in my links...

# August 14, 2008 4:54 PM

Kine said:

And one tip - you can make it much better and use editbox without borders etc., with BIG font size, and e.g. with character 'g' in 'Webdings' font to fill the background with selected color. Than you can set the FOREGROUND color in OnFormat and you have truecolor background possibility without any big code for each color... ;-)

# August 18, 2008 7:42 AM

Steve Farr said:

The Web Services competition in the UK is indeed serious and we have a few entries already. There is also a real prize (somewhat generous IMHO) of a classic sports car for a day. Open to all UK reselling and ISV partners.

# August 20, 2008 2:33 PM

waldo said:

Thanks for the info, Steve!

# August 20, 2008 9:35 PM

Alphonsus said:

Hi,

Sorry but I don't understand the part that said updates were language/country sensitive.

How do I check my NAV language?

Thanks

# August 21, 2008 8:27 AM

waldo said:

What installation did you use?  You have a localised installation (for example Spanish, Belgian, Italian, ...).  That's what you need ... you have to ask for the fix for the specific localised version.  Why?  Because it has to update the specific etx and stx files... .

# August 21, 2008 8:39 AM

77math said:

thanks so much

# August 23, 2008 11:31 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

The &quot;Key&quot; virtual table contains information about the keys that are defined in each table

# August 26, 2008 8:39 PM

waldo said:

The &quot;Key&quot; virtual table contains information about the keys that are defined in each table

# August 26, 2008 9:44 PM

Vjeko said:

Hi Waldo, great post again! I just wanted to comment that Object table is fully editable - you can even modify the contents of the BLOB Reference field. I have an example of it my Automated Version Management tool: dynamicsblog.wordpress.com/.../auto-versions

# August 27, 2008 12:09 PM

waldo said:

Thanks for the comment, Vjeko.

And I like your solution.  I'm going to try it out.

# August 27, 2008 2:24 PM

Vanrofi said:

I also have a problem with opening the presentation. I have office 2007...very curious to see the presentation.

# August 29, 2008 10:16 AM

waldo said:

I got the same problem. Actually, it's a pptx file, but it's downloaded as a .zip.

renaming the file from .zip to .pptx does the trick.

What's the cause? I don't know ...

# August 29, 2008 10:24 AM

waldo said:

Today, I received a very interesting summarizing mail from Microsoft with the announcement that SQL Server

# September 1, 2008 11:45 AM

waldo said:

Two posts in one day ... It&#39;s not really my habit, but it&#39;s just too interesting (and definitely

# September 1, 2008 3:46 PM

lnraju said:

I couldn't download the file, what may be reason

# September 8, 2008 2:38 PM

waldo said:

Did you try:

mbs.microsoft.com/.../General.aspx{D930E9B3-BB27-4E88-AFF1-D97CF27B5DB4}&NRORIGINALURL=/partnersource/documentation/userguides/MSDNAVlocalfunct&NRCACHEHINT=Guest&wa=wsignin1.0 ?

# September 8, 2008 2:51 PM

waldo said:

A new series of MSDN and TechNet evening sessions will be organised by Microsoft Belgium. And it&#39;s

# September 9, 2008 5:59 PM

DenSter said:

LOL in heart and kidneys, gotta keep that one :)

# September 9, 2008 11:09 PM

waldo said:

Smile hehe

You know Dutch ... what's the translation to English?

# September 10, 2008 7:51 AM

waldo said:

Here (finally) a new update of the current platform updates. One of the requests was to reverse the table

# September 13, 2008 6:37 PM

Natalie said:

The update link for CTP4 could not be found :-/

# September 13, 2008 7:40 PM

waldo said:

Well, it actually does, but you need access to MSConnect.  Partnersource access is not enough.

And to have access to MSConnect, you need to be signed up in the Beta Access Program.  I'm not sure if it's still possible to sign up, though... .

# September 15, 2008 8:16 AM

Natalie said:

I'm already registered on MSConnect, but they never answered my intention to sign in the Beta Access Programme (half a year ago??). They don't like me obviously :-/

# September 15, 2008 8:40 AM

waldo said:

All I know is that it's a partner-level decision, not a personal one.  It's not like being involved in vista or whatever.  Partners have to sign up and I guess individuals can't... .

# September 15, 2008 9:29 AM

wito said:

You can add this link as a summary fot the 50SP1 updates/hotfixes:

blogs.technet.com/.../microsoft-dynamics-nav-5-0-sp1-latest-available-version-build.aspx

for 40SP3 are two newer ones than the 6.10 that can be downloaded, see the link thats in your overview above (KB953313 and KB954342).

thanks again for the update.nice work!

# September 15, 2008 12:17 PM

waldo said:

Thanks!

I added the links for the next update.  Actually, one of them is an update of the BA Targit installer.  I only update this table with the platform update (i.e. fin(sql).exe, nas(sql).exe and dll's).

# September 15, 2008 1:44 PM

wito said:

Nope, both are platform updates. the one you mention is KB929047 :)

# September 15, 2008 4:24 PM

waldo said:

Hm, that link doesn't work.   May be it's too new ... I'll wait a few days.

Thanks, wito!

# September 15, 2008 4:41 PM

Eric said:

I am a member of connect, but the link to 2009 CTP4 does not work.

# September 16, 2008 7:55 PM

waldo said:

I tried the link to CTP4 with and without being logged in in msconnect.  Both worked like a charm.

:|.

The only thing I can say then is just log in to connect.microsoft.com, click on downloads and there you'll see the link.

Sorry for the link...:(

# September 17, 2008 6:54 AM

Natalie said:

On connect.microsoft.com there is no link to downloads :-/

Seems as if the design of that page strongly depends on your rights.

# September 17, 2008 11:51 AM

Sebastian said:

Hi Waldo,

when you get “inspiration” from other blogs, it would be nice if add a link back to the original, or at least mention it.

Thanks

Sebastian

# September 17, 2008 11:56 AM

waldo said:

@Natalie

You have to be signed up for the Microsoft Dynamics NAV program.  The downloads are under that section.

@Sebastian

I sense a little sarcasm in your comment Wink.  I always try to mention the sources, but i'm not perfect (not in the least) so tell me, what did I forget?

# September 17, 2008 1:10 PM

Alterant said:

My two cents concerning using of FINDSET with secondary key and using FINDSET(TRUE,TRUE).

First, about FINDSET with secondary key. As Waldo said using FINDSET will result in two queries:

SELECT TOP 500 ...

and cursor SELECT * ... WHERE PK > 500 ...

But it is true only for loops based on PK.

If you have a loop based on a secondary key you'll have extra queries.

For the table with two fields we will have the following picture:

First we will get first 500 recs:

SELECT TOP 500 * FROM "TestFindSet" ORDER BY "SecondKey","EntryNo"

SecondKey  EntryNo

A          1

...

A          500

Then we will have an extra query (cursor) to get the rest recs with SecondKey = 'A':

SELECT  * FROM "TestFindSet" WHERE  "SecondKey"='A' AND "EntryNo">500 ORDER BY "SecondKey","EntryNo"

SecondKey  EntryNo

A          501

A          502

A          503

A          504

A          505

And then we will have the query (cursor) to get the rest of the table:

SELECT  * FROM "TestFindSet" WHERE  "SecondKey">'A' ORDER BY "SecondKey","EntryNo"

B 506

...

More fields you have in the key more extra queries you will have. For example for the table with 3 fields where two of them are in the same secondary key we will have 2 extra queries:

1. SELECT TOP 500 ... OREDER BY "SecKey1", "SecKey2", "PK"

2. SELECT * ... WHERE "SecKey1" = zzz and "SecKey2" = xxx and PK > 500 ...

3. SELECT * ... WHERE "SecKey1" = zzz and "SecKey2" > xxx ...

4. SELECT * ... WHERE "SecKey1" > zzz ...

Now the most interesting part about using FINDSET(TRUE, TRUE).

When MS said "If you are going to modify any field value within the current key, set this parameter to TRUE." they didn't mean that you should use the same variable for looping and for modification (wich can lead to "NEXT from HELL" situation). You can look at example 3 of the help topic concerning FINDSET.

So what is the difference between FINDSET(TRUE) and FINDSET(TRUE, TRUE)?

FINDSET(TRUE) will open the cursor which will fetch a number of records at a time.

FINDSET(TRUE, TRUE) will result in the cursor which will fetch records one by one.

And you should know that during modification of the current key Navision will use the cursor which will fetch records one by one. This is the point.

The following example illustrates what will happen if you use FINDSET(TRUE) for key modification loop:

start reading

1. open cursor

2. fetch x

3. ...

4. fetch x

first modification occurs

5. close cursor

6. open cursor

7. fetch 1

8. modify

continue to modify

9. ...

10. fetch 1

11. modify

no more modifications at the moment - continue reading

12. close cursor

13. open cursor to read the rest of the records with the same values in the key (as described in the first part of my post)

14. close cursor

15. open cursor

16. fetch x

17. fetch x

another modification

18. close cursor

19. open cursor

20. fetch 1

21. modify

22. close cursor

23. open cursor to read the rest of the records with the same values in the key

24. close cursor

25. open cursor

26. fetch x

27. ...

28. close cursor

As you can see using FINDSET(TRUE) will result in a number of cursor creation and closing procedures.

As for FINDSET(TRUE,TRUE) the system will create the cursor only once, BUT it will fetch records one by one:

1. open cursor

2. fetch 1

3. fetch 1

4. ...

first modification occurs

5. fetch 1

6. modify

7. ...

no more modifications

8. fetch 1

9. fetch 1

10. ...

11. close cursor

So which method is preferable for loops with modifications of the key? In my opinion, unfortunately, there is no universal solution. If you are going to modify every second record in the table than FINDSET(TRUE,TRUE) will be the good choise.

But if you need to modify only a couple of records in the table with millions of records than I think using FINDSET(TRUE) is more convenient.

Hope this info will be useful.

# September 17, 2008 1:30 PM

Timo Lässer said:

# September 17, 2008 2:11 PM

waldo said:

I am aware of that blog.  He/She/They have also access to not-yet-realeased-to-public kb articles.  I only have access to the released ones.  Anyway, not all of them will become public either.

Anyway, I added the link to 4.0Sp3 above, and the new one (5.0 Sp1) in the new (yet-to-be-published) list.  I hope this helps you.

Thank you for the comments!  I appreciate it.

# September 17, 2008 5:18 PM

waldo said:

I wanted to get your attention to a new blogger: Claus Lundstrøm . OK, I hear you thinking &quot;just

# September 22, 2008 9:12 AM

Kine said:

S..t, once again I will not be the first one with that... :-(       ;-)

# September 22, 2008 2:57 PM

waldo said:

You're the third one that says that to me.

Seems that many people are really waiting to start blogging about NAV2009...

# September 22, 2008 3:44 PM

DenSter said:

Want to but can't because of NDA.

# September 22, 2008 7:42 PM

Alex Chow said:

Hey Eric, are you sure the color is not just the work of photoshop?  ;-)

# September 22, 2008 8:06 PM

waldo said:

Who will tell Wink?

# September 23, 2008 7:50 AM

Waldo's Blog
Microsoft Dynamics NAV
said:

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

# September 25, 2008 2:38 PM

waldo said:

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

# September 26, 2008 12:44 AM

Blogwelle zu NAV 2009 gestartet » Blog der Microsoft .NET / Dynamics NAV - Group Halle said:

Pingback from  Blogwelle zu NAV 2009 gestartet &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

# September 26, 2008 11:44 AM

DenSter said:

Good stuff eh Eric :) finally we can talk about this, get rid of some of the wrong ideas floating around out there, and maybe get people excited just like we are.

# September 27, 2008 7:54 AM

azerty said:

How was the "Hardware recommendations" session ? Unfortunately I was unable to attend, although I really wanted to be there...

# October 1, 2008 9:17 AM

waldo said:

If you browse through the threads of MiBuSo or DynamicsUser.net , you come across posts where people

# October 1, 2008 5:45 PM

waldo said:

In my opionion, the hardware-session was a success.  I'm willing to write about it, but I don't find the time... .  Sorry... .

# October 3, 2008 8:36 AM

NAV 2009 Launch | Programmer's Edge said:

Pingback from  NAV 2009 Launch | Programmer's Edge

# October 3, 2008 9:04 PM

NAV 2009 Launch | Programmer's Edge said:

Pingback from  NAV 2009 Launch | Programmer's Edge

# October 3, 2008 9:04 PM

Erik P. Ernst said:

I think I said it before - but this blog post is GOLD!

# October 15, 2008 12:40 PM

waldo said:

You can't say it enough in my opinion :-)

# October 15, 2008 1:48 PM

kriki said:

I think someone said it before - but this blog post is GOLD!  :-)

# October 15, 2008 2:48 PM

waldo said:

Haha

# October 15, 2008 2:57 PM

waldo said:

I&#39;m getting a little bit lazy, so it seems. I&#39;m sitting here, five minutes before the very first

# October 20, 2008 4:00 PM

Waldo's Blog
Microsoft Dynamics NAV
said:

This first session (at a killing starting time of 8am in the morning ) was presented by Tom Loyal and

# October 20, 2008 5:15 PM

waldo said:

That&#39; s big title . If you&#39;ve read my first post (introduction) ... one might have a feeling

# October 20, 2008 6:01 PM

waldo said:

This first session (at a killing starting time of 8am in the morning ) was presented by Tom Loyal and

# October 20, 2008 6:01 PM

waldo said:

This next session is one of the &quot;Implementor&quot; tracks. I&#39;m not an implementor, and I don&#39;t

# October 20, 2008 10:01 PM

waldo said:

The past years you could feel Microsoft pushing people (and the product) to Sharepoint. Being a succesful

# October 20, 2008 11:01 PM

DenSter said:

I was also hoping for more of a general NAV/sharepoint session, and I kind of expected to see an infopath webpart consuming a NAV2009 webservice, and I was very disappointed to see it was just another EP demo. It was the best EP demo I've seen so far though, very clear, and a complete runthrough of the entire process, from setting it up in NAV to seeing it work on Sharepoint.

# October 21, 2008 4:44 AM

DenSter said:

A good session overall, nice presentation (although Tom Loyal was a bit too happy too early in the morning for my taste :)). I enjoyed the information and it will help a lot of people get started in SSRS.

# October 21, 2008 4:47 AM

waldo said:

This is a session of my good friend and fellow MVP Daniel Rimmelzwaan (aka Denster on Mibuso). I&#39;m

# October 21, 2008 3:02 PM

DenSter said:

I liked this session a lot, especially the way they took it down to more of an operational level, instead of a management type overview.

# October 21, 2008 5:29 PM

waldo said:

BI is hot today. BIO Analytics is a company that built BI tools for Dynamics NAV, called BIO for Dynamics

# October 21, 2008 6:02 PM

Mark Brummel said:

Sounds like a great session. Good job Daniel, nice blog Eric.

Wish I could be there...

# October 21, 2008 7:54 PM

Gaspode said:

Hi Waldo, what sort of delay does the iFacto NAS Scheduler have between receiving a request, starting up the new NAS for the correct company and being able to handle the request? Maybe it can only be used for scheduling jobs and not this kind of message handling. Cheers, Dave.

# October 22, 2008 3:41 AM

waldo said:

Hi Dave.  Thanks for asking this question.

The NAS Scheduler focuses indeed in scheduling jobs that have to be executed on a certain time, in a certain interval.

When you want to work with MSMQ, you can't use the NAS Scheduler (as it's is timer-based, not event-bases, which is necessary for MSMQ).

We were thinking about extending it though ... but it's not in the scope (yet) :-).

# October 22, 2008 3:00 PM

waldo said:

Who doesn&#39;t want to follow that session? :-) I heard this session is going to be about the form transformation

# October 22, 2008 3:15 PM

Alex Chow said:

Your opinion is correct. I also think it's faster to create a page from scratch instead of transforming it.

# October 22, 2008 3:52 PM

DenSter said:

If you have the need to keep forms as well as pages then this could be a good strategy, although it did look like keeping forms and pages synchronized is a lot of work, and I wonder what would happen if you decide to not synch one of them, or a number of them, it becomes very difficult to manage. For situations where you don't need to have forms as well as pages (i.e. when all you need is the RTC), I think it serves you better to do development straight in the page designer.

What I wonder though, is whether we'll get a page wizard that will help us a little more than just set the page type.

# October 22, 2008 10:08 PM

waldo said:

It&#39;s a tradition. After a convention I always try to write some &quot;thoughts&quot;. Has it been

# October 28, 2008 2:30 PM

Where Am I? Now I know! - Gaspode's Brain Dump said:

Pingback from  Where Am I? Now I know! - Gaspode&#39;s Brain Dump

# October 28, 2008 3:19 PM

Waldo's Blog Microsoft Dynamics NAV said:

It&#39;s a tradition. After a convention I always try to write some &quot;thoughts&quot;. Has it been

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

Who doesn&#39;t want to follow that session? :-) I heard this session is going to be about the form transformation

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

This is a session of my good friend and fellow MVP Daniel Rimmelzwaan (aka Denster on Mibuso). I&#39;m

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

The past years you could feel Microsoft pushing people (and the product) to Sharepoint. Being a succesful

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

This next session is one of the &quot;Implementor&quot; tracks. I&#39;m not an implementor, and I don&#39;t

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

If you browse through the threads of MiBuSo or DynamicsUser.net , you come across posts where people

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

I wanted to get your attention to a new blogger: Claus Lundstrøm . OK, I hear you thinking &quot;just

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

Here (finally) a new update of the current platform updates. One of the requests was to reverse the table

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

A new series of MSDN and TechNet evening sessions will be organised by Microsoft Belgium. And it&#39;s

# October 28, 2008 3:20 PM

Waldo's Blog Microsoft Dynamics NAV said:

Two posts in one day ... It&#39;s not really my habit, but it&#39;s just too interesting (and definitely

# October 28, 2008 3:20 PM

Microsoft Dynamics NAV Team said:

Last month (23 rd – 25 th April), Claus Lundstrøm and I took to the road and drove all the way from Vedbæk

# October 28, 2008 3:52 PM

Microsoft Dynamics NAV Tech & NAV in Baltic said:

Few new articles about NAV on SQL released by experts: Lars Lohndorf-Larsen article &quot;Record-level

# October 28, 2008 3:53 PM

Waldo's Blog Microsoft Dynamics NAV said:

Today, I got the message that Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server

# October 30, 2008 5:14 PM

waldo said:

Today, I got the message that Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server

# October 30, 2008 6:00 PM

DenSter said:

Thanks for posting this Eric, I was waiting for that announcement.

# October 30, 2008 7:38 PM

Scott said:

Thank you for posting this! :-) Just one small correction, an update is needed if customers are using Business Notifications and/or Commerce Gateway, not Business Analytics. From the PartnerSource announcement:

...

"The only product update to be aware of applies for customers who take advantage of Business Notification and / or Commerce Gateway functionality."

...

# October 30, 2008 9:12 PM

David Singleton said:

I have one client that is running 4.0SP3 on Win2k8 SQL2005. They upgraded form Win2k3 because they were told it would speed up Navision.

Speed wise there was no change, but it does seem very stable and nice to use.

In fact I am thinking of installing Win2k8 on my next lap top instead of Vista.

# October 31, 2008 1:58 AM

waldo said:

In fact, I know someone who is running Hyper-V on his laptop ... running more than one operating system in this way Indifferent.  Seems a little bit overkill for me ... but anyway... .

# October 31, 2008 9:12 AM

waldo said:

@Scott.

You're right, I changed it in my text... .  Thanks for the heads-up!

# October 31, 2008 9:18 AM

clausl said:

Business Notification will not be able to support Microsoft SQL Server 2008 before the "SQL Server 2005 Notification Services Components Package" has been released. Currently this in RC1 state. Business Notification is dependent on this component in SQL Server, and this was not included in SQL Server 2008 RTM.

Please ready more about the availability of "SQL Server 2005 Notification Services Components Package" here:

forums.microsoft.com/.../ShowPost.aspx

When "SQL Server 2005 Notification Services Components Package" has been Released to Web, we of course need to verify that Business Notification works with SQL Server 2008 included the "SQL Server 2005 Notification Services Components Package" before we can claim support for Business Notification on SQL Server 2008.

Regards,

Claus Lundstrøm, Program Manager, Microsoft Dynamics NAV

# October 31, 2008 4:13 PM

waldo said:

Thanks for the comment, Claus.  

Indeed very important.  I will update my post with this info to make it more visible.

# October 31, 2008 4:46 PM

Burim Avdiu said:

I fixed this problem.

Uninstall the Navision sp3 and just install Navision sp1.

Or download the updates.

# November 7, 2008 11:26 AM

Waldo's Blog Microsoft Dynamics NAV said:

Some time ago, I explained how you could use ADO to call stored procedures and stuff ... . Just another

# November 8, 2008 4:03 PM

waldo said:

Some time ago, I explained how you could use ADO to call stored procedures and stuff ... . Just another

# November 8, 2008 4:16 PM

Robert said:

I just wanted to add a note that Navision doesn't really like linked objects. They do work and often well, but with problems.

The first you've noted, a Nav restore will fail without the view in place; but if the view is based on tables in a company you won't be able to create the view until the company is restored. Luckily when the restore falls over you can create the views and continue the restore.

I haven't found any solution to the second problem; you just cannot rename companies with linked objects without deleting the objects.

BTW: The comment above: using ADO from NAV to create the views is a very good idea; that way you don't go misplacing the script.

# November 10, 2008 6:06 PM

waldo said:

Thanks for you comment, Robert, I appreciate it.

The restore is indeed a problem.  But you can do it another way:

1) create a new db

2) import all objects from the backup file (fdb) (you can do this with file/import/view all files)

3) create the views

4) restore from the same fdb

The renaming is indeed a ***.  But that doesn't happen a lot, does it Smile.

# November 10, 2008 6:57 PM

Robert said:

Sorry, step 3, creating the views, fails when the view is based on a table in the company that doesn't exist yet.

You should get an error free restore if you create FAKE views at this point and replace them at the end.

Oh and you can restore "only the objects" in (2) you only need to treat the fbk as a fob if you've already loaded some objects into the DB. But it is a really neat trick then.

> The renaming is indeed a ***.

On SQL, always!

It's often faster to backup and restore to rename on a native DB!!!

But some people seem prepared to wait.

# November 10, 2008 7:47 PM

waldo said:

You're right, sorry.  You should create the compay first before creating the view, but then, you should delete (or rename) the company before you restore the backup.  Anyway ... different workarounds, one conclusion: no one straight way to do it.

# November 11, 2008 2:40 PM

Jörg A. Stryk said:

Hi Eric!

Great BLOG! In my projects I oftenly use Views & Linked Objects, e.g. to easily display JOINED or AGGREGATED data, which would be a real "pain" to do in C/SIDE ...

Regarding "performance", indeed, it could be quite poor - depending on the View. But since SQL 2005 Views could be INDEXED to speed up performance - as shown with VSIFT in NAV 5.0 SP1!

Using Views & Linked Objects gives us LOTS of possibilities: you could create a View on a "Linked Server", which e.g. could be an Excel sheet (ODBC source) or a remote Database etc.. For example, you could link a - separate - DB with historical data; thus using historical info TOGETHER with current NAV data ... or transfer/migrate master data directly from an Excel sheet (which would be eveb faster when doing a INSERT / SELECT in SQL) ... and much more!

SQL Server IS POWERFUL! And besides MSADO, Views & Linked Objects are a GREAT option to use this POWER in NAV! (IMHO)

Best regards,

Jörg

# November 11, 2008 3:16 PM

Erik P. Ernst said:

The "cool" thing about this, is that it has actually been possible to do at least since version 3.60, so it's not new. But I think not many developers know this. We used it to display values of other SQL databases directly in Navision.

# November 11, 2008 4:17 PM

waldo said:

Thanks for the comments, guys.

We use it for the same things... .  Throwing in some ADO, SP's, Views ... combination of  all... .  But, as mentioned before, I always try to build it 'as generic as possible'.  I mean, if a new company is created .. the new "views" have to be created as well.

It's not only powerful, it's also interesting.  At the moment, we're designing a solution where we use SQL Triggers.  Just a design phase, but interesting enough to explore the possibilities...

# November 11, 2008 9:56 PM

Raghuveer said:

Is Windows Server 2008 + Nav 4.0 SP3 really compatible ? We are facing service start error.

# November 14, 2008 6:51 AM

kriki said:

Nice blog!

I do know of the possibility from the beginning, but because of the problems involved, I try to avoid them.

The way I would do it, is to create a new DB (NOT NAV!). In this DB I define all the views (and maybe also tables if needed). In NAV I use ADO to read the tables/views in that other DB. This way the NAV-DB remains 'clean'.

Also if the views are on another DB, I do this. This way, with ADO I just need to access that DB and not multiple others. This way also the other databases remain 'clean'.

If I need the view on a form, I read the data through ADO in a temptable and then show the temptable. Of course, this is only possible if there are not too many records and the view-query is fast enough (here indexed views can help).

# November 14, 2008 9:33 AM

kriki said:

BTW : talking about ADO: thanks for your blog on it. It was very helpful to get started!

# November 14, 2008 9:37 AM

waldo said:

Well ... it's supported by Microsoft, so you can contact them to support you... .

Which build are you on?

# November 14, 2008 9:39 AM

waldo said:

Smile

I use that post always as a reference myself... .  That way, my blog is my tiny little knowledge base Wink.

# November 14, 2008 10:13 AM

Raghuveer said:

My Build: Navision 4.0 SP3 - India, let me know what exactly build you wish to know and where I can fetch that from my system.

# November 14, 2008 10:46 AM

waldo said:

Here is an overview of the current builds:

dynamicsuser.net/.../platform-updates-overview-3-70-b-nav2009-ctp4.aspx

If you want to know your build, just doubleclick on the version number in the About window of Dynamics NAV.

# November 14, 2008 11:05 AM

Waldo's Blog Microsoft Dynamics NAV said:

My intention with this (planned) series of blog posts, is to give you some tips and tricks regarding

# November 15, 2008 11:29 AM

waldo said:

My intention with this (planned) series of blog posts, is to give you some tips and tricks regarding

# November 15, 2008 11:31 AM

Raghuveer said:

In the first place, I am unable to install NAV 4.0 SP3 on Windows Server 2008, during installation, during service start, getting error and unable to complete the installation.

# November 17, 2008 7:45 AM

waldo said:

Well, the only thing I can say is that Update 6 was included in the default SP3 download after some time.  May be you're installing from an "old" 4.0Sp3?  Can you download a fresh copy and try again?

# November 17, 2008 10:35 AM

Raghuveer said:

Thankyou verymuch. I did a fresh copy download and installed, everything went fine.

# November 17, 2008 12:16 PM

Dave said:

I'm installing Dyamics NAV 5.0 SP1 on a Vista machine and am consistantly getting an error during the installation.  I've also got the same program, from the same install, running on 3 other Vista machines (one of which is a mirror of the hardware and installed at the same time).

OS = Vista Businesss 32bit

Dynamics - NAV 5.0 SP1

Error Code: 1935 - An error occured during the installation of assembly component.

Google searches point to a .net issue, but I can't find anyone who's got a sucessful fix for it.

# November 17, 2008 1:02 PM

waldo said:

Some suggestions:

- download the installation again and try again

- Run the MSI directly (not setup.exe)

- Run with admin rights

# November 17, 2008 1:21 PM

KR said:

Thanks a lot! Great Blog! It really help me!

# November 19, 2008 3:35 AM

waldo said:

Shame on me … but this message is too late. You&#39;ll probably know it for a while but still … I&#39;m

# November 22, 2008 3:58 PM

Amarnath said:

Hi guy can u actually tell me how to hold a SQL server for many user from different network system to access the database and to work on some database alone.

# November 27, 2008 9:33 AM

waldo said:

Sorry man, I really don't get what you mean.  Can you give me more details?

# November 27, 2008 11:43 AM

Waldo's Blog Microsoft Dynamics NAV said:

Just wanted to get your attention to something quite important. Until the end of the year, to be a certified

# November 30, 2008 8:31 PM

waldo said:

Just wanted to get your attention to something quite important. Until the end of the year, to be a certified

# November 30, 2008 8:45 PM

Silent said:

So, if we are MCP, but for now we don't have, for example, Microsoft Dynamics NAV Installation & Configuration certificate, then we will be blocked in January?

# December 1, 2008 10:40 AM

waldo said:

I'm afraid so ... best is to contact your PAM... .

# December 1, 2008 12:15 PM

Alex Chow said:

It's SQL exam 70-431 -OR- 70-432.

If you need to study one, just go for 70-432 since it's for SQL 2008

# December 1, 2008 6:46 PM

AdamRoue said:

Microsoft are always changing this :-)

When they took over Navision they made accreditation dependent upon SQL server exam and others, then it was also with some core and elective exams, then they overlayed gold partner, then for the past few years they juggled around with the accreditations.

Still nice to know what they expect from next year - although if you are big enough they do by pass this requirement!

# December 2, 2008 12:09 PM

babrown said:

A typical NAV developer will never touch 75% of the subjects tested in that SQL exam.  It would be nice if they devised certification requirements that were actually consistent with the job requirements.

# December 2, 2008 9:48 PM

waldo said:

Well, I never took that exam, so I wouldn't know.  

But on the other hand, I can imagine... .

# December 3, 2008 2:30 PM

babrown said:

Don't count on them overlooking this rquirement even for larger organizations.  I work for one of those "larger" organizations and our management was told that this requirement would not be overlooked.

# December 3, 2008 11:52 PM

waldo said:

Yeah, we got that same "warning" ourselves (today).

# December 4, 2008 4:15 PM

waldo said:

Time for another overview (it has been a while, hasn't it?). Well, NAV 2009 was officially released

# December 7, 2008 10:55 AM

Waldo's Blog Microsoft Dynamics NAV said:

Time for another overview (it has been a while, hasn't it?). Well, NAV 2009 was officially released

# December 7, 2008 11:07 AM

Jan Vesel said:

Is a Microsoft Dynamics NAV 4 SP3 also compatible with Microsoft SQL Server 2005 and Microsoft Windows Server 2008?

# December 11, 2008 2:01 PM

waldo said:

It is...

# December 11, 2008 2:17 PM

Jay Malik said:

We wanted to jump up during this session to brag about Pivotier which enables Reporting Services for Dynamics NAv data including support for flowfields and option fields.  Now NAV users can use Report Builder as we automatically create Report Models with flowfields, etc.  Also ad-hoc reports without using the Builder.

See

www.centerlinesft.com/.../pivotier.html

for more.

# December 11, 2008 4:17 PM

waldo said:

At the latest Convergence EMEA (Copenhagen) some MVP's were asked to be (video-) interviewed by Bruce

# December 11, 2008 5:46 PM

Waldo's Blog Microsoft Dynamics NAV said:

At the latest Convergence EMEA (Copenhagen) some MVP's were asked to be (video-) interviewed by Bruce

# December 11, 2008 5:48 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

# December 18, 2008 5:42 PM

Waldo's Blog Microsoft Dynamics NAV said:

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

# December 18, 2008 6:03 PM

waldo said:

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

# December 18, 2008 6:29 PM

babrown said:

Customers need to review their licensing options for both SQL and server operating systems and select the option that fits their situation the best.  While one option may have a cheaper initial purchase it may not be the cheapest in the long run as the system is updated and expanded.  In my experience there is not "one size fits all" solution.

# December 20, 2008 1:05 AM

waldo said:

True ... and don't get me wrong.  I'm not really a "runtime license"-fan myself..  I would rather keep all options open at all times.

# December 21, 2008 8:54 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:55 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:55 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:55 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:55 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:55 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:55 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:55 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:56 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 10:59 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:00 AM

Erik P. Ernst said:

Hi Eric,

Thank you. I must say that you have had a great blogging year! Not only I have really enjoyed reading your posts, but I think that everybody did that also. If there was a price for the best blog on http://dynamicsuser.net, then I'm sure that you would win that. And thank you for the overview.

Merry Christmas and a Happy New Year!

# December 24, 2008 11:28 AM

waldo said:

Thanks, Erik.

So, why isn't there a price? Smile

# December 24, 2008 11:33 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:35 AM

waldo said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:44 AM

Waldo's Blog Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 24, 2008 11:53 AM

Erik P. Ernst said:

Well there's no price because nobody have suggested this until now. Maybe we should include when we run the next "DUG Community Price", which we also ran this year.

# December 24, 2008 12:19 PM

Natalie said:

Hey Eric,

thanks for your commitment this year and keeping us up-to-date.

Keep on!

Merry Christmas,

Natalie

# December 24, 2008 1:18 PM

waldo said:

Thanks Natalie, and also thanks for spreading the word in the German community.

Happy Holidays to you too!

# December 25, 2008 2:22 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:23 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:24 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:24 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:24 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

# December 25, 2008 2:24 PM

Rashed Amini said:

I just wanted to add some additional suggestion.

When using recordset variable. Add it as local otherwise you will get an error for duplicate Variable.

Second. When running a sql statement that returns a record set, for Decimal values etc, you will get an error

This message is for C/AL programmers:

This data type is not supported by C/SIDE. You can access data of any of the following data types: VT_VOID, VT_I2, VT_I4, VT_R4, VT_R8, VT_CY, VT_DATE, VT_BSTR and VT_BOOL"

You can change you sql statement and use cast function

Select Amount

from Customer

to

Select cast (Amount as float)

from Customer

# December 26, 2008 4:08 PM

waldo said:

Thanks, Rashed !

# December 29, 2008 11:24 AM

waldo said:

I realize this is not really "brand new information", and probably you all already know about

# January 6, 2009 10:18 PM

Waldo's Blog Microsoft Dynamics NAV said:

I realize this is not really "brand new information", and probably you all already know about

# January 6, 2009 10:41 PM

Vjeko said:

Hi Waldo,

Thanks for kind words, I really appreciate it! And thanks for giving such a good reference to both my and Dave's blogs! Have you got your copy of the book already?

# January 13, 2009 11:31 PM

waldo said:

Yep, I received it yesterday, thanks!

I'm curious which of my comments are included in the book ;-)

# January 14, 2009 9:34 AM

Peter said:

Suggestion for the next version of this great list:

blogs.technet.com/.../microsoft-dynamics-nav-2009-available-builds.aspx

# January 14, 2009 2:49 PM

Gaspode said:

Hi Waldo, I'm pleased you've received your copy of the book. I'm still waiting for mine - I guess that's what you get for being on the other side of the world!

I can tell you that, for my chapters, I took action on every single one of your comments - you made a significant contribution to this book and I can recomend you as an excellent technical reviewer. But I still didn't write that chapter on upgrading you wanted so much :-)

# January 16, 2009 9:27 AM

Waldo's Blog Microsoft Dynamics NAV said:

The next big convention is almost there … and in one of the most interesting cities: New Orleans

# January 18, 2009 1:54 PM

waldo said:

The next big convention is almost there … and in one of the most interesting cities: New Orleans

# January 18, 2009 2:34 PM

waldo said:

A new serie of MSDN/Technet evening-sessions regarding Microsoft Dynamics NAV is planned in Belgium.

# February 8, 2009 12:51 PM

Waldo's Blog Microsoft Dynamics NAV said:

A new serie of MSDN/Technet evening-sessions regarding Microsoft Dynamics NAV is planned in Belgium.

# February 8, 2009 1:06 PM

Waldo's Blog <br /> Microsoft Dynamics NAV said:

It's time to announce the second 'edition' of Directions EMEA . What is Directions? Directions

# February 20, 2009 3:22 PM

kriki said:

New one :

 -5.0SP1

 -KB963700:

 -Build:28412

mbs.microsoft.com/.../KBDisplay.aspx$en-us$963700

# February 27, 2009 11:52 AM

Waldo's Blog Microsoft Dynamics NAV said:

There is quite some new info again. Just go over the italic text below to see what I added/changed. Here

# March 5, 2009 12:16 AM

waldo said:

There is quite some new info again. Just go over the italic text below to see what I added/changed. Here

# March 5, 2009 12:28 AM

Usha said:

Very Interesting! and its very useful for me to understand about "Find". By your Blog i get things how C/AL will have in SQL.

Thank you for the nice Blog...

# March 9, 2009 8:49 AM

waldo said:

No problem, Asha.

In my opinion, it's important any developer understands what's going on on the server when he writes certain peaces of code... .

# March 9, 2009 5:52 PM

Waldo's Blog Microsoft Dynamics NAV said:

Another Convergence is just around the corner … and yes, waldo is attending … again. And

# March 9, 2009 6:10 PM

waldo said:

Another Convergence is just around the corner … and yes, waldo is attending … again. And

# March 9, 2009 6:14 PM

waldo said:

I'm not a fan of Keynotes, but still, I forced myself to go. Tuesday morning 9am. After quite an

# March 10, 2009 5:27 PM

Waldo's Blog Microsoft Dynamics NAV said:

I'm not a fan of Keynotes, but still, I forced myself to go. Tuesday morning 9am. After quite an

# March 10, 2009 5:53 PM

Erik P. Ernst said:

Hi Eric,

Thank you for your report. Sounds like there's not so much new compared to the Convergence in CPH last fall.

# March 10, 2009 10:47 PM

waldo said:

The first "concurrent session" of this Convergence for me. One not to miss. Freddy Kristiansen

# March 11, 2009 5:29 AM

Waldo's Blog Microsoft Dynamics NAV said:

The first "concurrent session" of this Convergence for me. One not to miss. Freddy Kristiansen

# March 11, 2009 5:37 AM

DenSter said:

Longitude and lattitude Eric :) Thanks for the blog, very informative as always

# March 11, 2009 3:53 PM

Erik P. Ernst said:

Great post. Nice to get some "real-life" examples! :)

# March 11, 2009 4:15 PM

ultiboy said:

Merci de partager tout ca avec nous!

# March 11, 2009 5:42 PM

waldo said:

Thanks guys (and indeed ... lattitude ... oh my god :-|)

# March 11, 2009 9:59 PM

waldo said:

As a personal interest, I attended this session about Microsoft Dynamics NAV CRM. As you know, already

# March 11, 2009 10:44 PM

Waldo's Blog Microsoft Dynamics NAV said:

As a personal interest, I attended this session about Microsoft Dynamics NAV CRM. As you know, already

# March 11, 2009 10:53 PM

Waldo's Blog Microsoft Dynamics NAV said:

Mauro Marinilli and Tom Loyal will be covering some topics about "End User productivity" and

# March 12, 2009 2:06 AM

waldo said:

Mauro Marinilli and Tom Loyal will be covering some topics about "End User productivity" and

# March 12, 2009 2:45 AM

Erik van den Berg said:

Thx for wrting this.

# March 12, 2009 6:30 PM

Gaspode said:

Hi Waldo, thanks once again for taking the time to write about convergence. I really look forward to reading you reports.

Cheers, Dave.

# March 12, 2009 6:52 PM

Erik P. Ernst said:

Hi Eric,

Thank you for sharing. Quite a lot of great tips.

# March 12, 2009 9:55 PM

Waldo's Blog Microsoft Dynamics NAV said:

Olga T. Mulvad is hosting this session. Being program manager of the Form Transformation tool (quite

# March 12, 2009 11:28 PM

waldo said:

Gladly done :-).

By the way, your book is one of the first to be sold out :-).

# March 12, 2009 11:41 PM

Erik P. Ernst said:

Thanks for sharing this Eric. And a great extension to have pictues from the event as well.

# March 13, 2009 1:59 PM

Gaspode said:

Hi Waldo, thanks again for your posts. What do you mean the Run command for pages (in the Object Designer) works. Are you talking about an upcoming feature - this doesn't work in my version of 2009.

# March 14, 2009 8:33 AM

waldo said:

wow, you really read this :-)

Well, I saw Olga push the "Run" button .. and the page popped open.  So she must have worked with the upcoming version then.

# March 15, 2009 2:58 AM

waldo said:

That's it again. Convergence 2009 in New Orleans is over. Just below 7000 people have been heading

# March 16, 2009 8:44 AM

Waldo's Blog Microsoft Dynamics NAV said:

That's it again. Convergence 2009 in New Orleans is over. Just below 7000 people have been heading

# March 16, 2009 8:58 AM

Mark Melton said:

Hello Waldo. I have been searching the net, hoping you wrote something somewhere that will help me specifically about sending a SQL query into SQL Server from NAV using C/SIDE variables. Here is the link: mibuso.com/.../viewtopic.php, the topic is: Question for Waldo and the Gurus.

Cant wait to read your input. I know you can help me. Please!

# March 16, 2009 11:46 AM

Erik P. Ernst said:

Hi Eric,

It was a pleasure, as always, reading your diary posts from Convergence. For all of us who have not been able to participate, it has been nice to been able to follow the conference.

So what Convergence location did you think have been the best so far:

San Diego (my favorite so far - wonderful nearby downtown and great outdoor welcome night)

Copenhagen

Munich

New Orleans

Orlando

# March 17, 2009 1:01 PM

Erik P. Ernst said:

PS: Maybe I always helped getting your "hits" up for convergence, as I had "promoted" your Convergence posts to "DUG News" so that they was displayed in the "DUG News/Announcement" rotation on the frontpage.

# March 17, 2009 1:02 PM

waldo said:

Good that you did that :-).

San Diego was by far the best location.  Not only because of the weather and downtown activities.  But also the conference building itself was good (logistic wise).  Long traveling time from Belgium though...

# March 17, 2009 1:12 PM

Erik P. Ernst said:

Yes the traveling time is really the only downside to San Diego. And in general then I find that Convergence in the US is much more fun than when it's in Europe. They really understand to make everything into a party over there!

# March 17, 2009 1:48 PM

Navigate Into Success said:

Spring has come. You can tell it. Okay, to be totally honest, nature and weather, at least over here

# April 4, 2009 8:56 AM

Waldo's Blog Microsoft Dynamics NAV said:

Well, this has been a weird convention for me. I have been doing a lot and nothing at the same time.

# April 9, 2009 12:35 AM

waldo said:

Well, this has been a weird convention for me. I have been doing a lot and nothing at the same time.

# April 9, 2009 1:04 AM

kriki said:

> In Belgium, people (and even Microsoft) are not really thinking about this yet … can you believe that?

Yes I can. The same in Italy...

# April 11, 2009 3:33 PM

waldo said:

I notice that (at least in Belgium) it's still quite a "hot topic" on how to handle NAV

# April 17, 2009 10:48 AM

Waldo's Blog Microsoft Dynamics NAV said:

I notice that (at least in Belgium) it's still quite a "hot topic" on how to handle NAV

# April 17, 2009 10:49 AM

Gaspode said:

Hi Waldo, thanks for this collection of posts. I've been using the transformation tool on my current project and by and large it has worked OK. I needed to make some modifications to add the Version List to the table and to update this from the Object table, this helped me to transform all of those forms I have edited in one go. I've deliberately tried to take the approach that I never edit a page directly and everything is done through transformation. This has a helped a lot since it means I never run the risk of having code that is out of synch between form and page. I have come across a couple of things that I don't know how to make happen so I think I need to do some more reading.

Cheers,

Dave.

# April 18, 2009 12:33 AM

Navigate Into Success said:

April. There is definitely something upside down with this month. I’ve started it with a somewhat ambitious

# May 4, 2009 3:09 AM

waldo said:

Here is a new update of the platform update list. Microsoft is not making it easy on my. They are providing

# May 8, 2009 1:49 PM

Waldo's Blog Microsoft Dynamics NAV said:

Here is a new update of the platform update list. Microsoft is not making it easy on my. They are providing

# May 8, 2009 1:52 PM

waldo said:

Hey Wito, long time no see ;°).

Thanks for the links.  I checked it and indeed some more (yet unpublished) hotfixes are available.

But be careful with the 4.0Sp3 list.  KB962005 is one for 5.0, not 4.0.

# May 11, 2009 10:18 AM

waldo said:

The new Statement Of Direction has appeared, and what a show! There is a roadmap until 2017 with features

# May 11, 2009 2:07 PM

Waldo's Blog Microsoft Dynamics NAV said:

The new Statement Of Direction has appeared, and what a show! There is a roadmap until 2017 with features