This is the final part in a three part series of blog posts. In part 1 I wrote about how you could use a couple of fields in the $ndo$dbproperty table to create a ConvertInvalidChars() function that would turn your NAV company name into the prefix for the table name as it is used in the SQL database. Then in part 2 I showed you how to create a SQL script
In last week’s post I wrote about how you could use a couple of fields in the $ndo$dbproperty table to create a ConvertInvalidChars() function that would turn your NAV company name into the prefix for the table name as it is used in the SQL database. This week we’re going to write some SQL that will create a dynamic select statement that we can use
The Linked Table Have you ever wanted to search across multiple companies in a NAV database simultaneously? It's really not that difficult as long as you're using a SQL database. In this series of blog posts, I'll give you a step by step guide on how to create a combined vendor list. This principal can be applied to any of the tables in
In order to drive awareness of the recent launch of Visual Studio 2010, Microsoft has given me 2 x Not for Resale (NFR) Visual Studio 2010 Ultimate with MSDN subscription cards to give away . Take a look on the Visual Studio Product Site and you’ll see that to buy one of these subscriptions will set you back a lot of money—but I’m giving them away for
When you want to attach an image to an Action in NAV 2009, you need to pick from one of the standard images and use it to set the Image property. There’s a library with all of the 2009 and 2009 SP1 images on MSDN ( http://msdn.microsoft.com/en-us/library/dd568728.aspx ). If you don’t know about Action Images, take a look at How to: Set an