Need to restart NAV Server to get new objects
Published 2012-2-27 21:36 | Gaspode
Have you ever had a situation where you need to restart your NAV Server in a three-tier setup in order to get it to pick up new FOBs after importing? In this blog post, I’ll look at some of the reasons why this can occur and give you some techniques for fixing it. No login for dbo alias The other day I came across this situation (actually found it through getting a whole bunch of errors in the application log on the NAV Server) where the database didn’t have a login for the dbo alias. This can happen...
Filed under: , , , ,
Ridiculously Cheap E-book
Published 2012-2-19 21:17 | Gaspode
This blog post is not about Dynamics NAV, so if you are only interested in Dynamics NAV. Stop reading now. Still here? Phew! I wrote a novel. It took me ages (around two years). You can buy it if you want. I’d really like you to. It’s ridiculously cheap (99c in the amazon.com store). So here’s the thing. I thought I’d write a blog post about some of the reasons behind why I wrote the novel, like why I think computer programmers aren’t boring geeks. Like how I wanted to create a tough-guy action hero...
Filed under: , ,
Config File Gotcha
Published 2012-2-3 22:08 | Gaspode
I came across something that was a bit weird in an implementation where every user in a Citrix deployed RoleTailored client suddenly connected to the TEST system instead of the LIVE system. I thought I’d share this gotcha to save others from making the same mistake. When you start Dynamics NAV 2009’s RoleTailored client, there are a three ways for the client to determine which server to connect to. This is handy to know because most people want to have a live system and a test system shortcut on...
Filed under: , , ,
Service Tier and Classic Client Monstrous Nightmare with FieldRef
Published 2011-8-12 22:49 | Gaspode
I came across an error today that was a monstrous nightmare to track down. First of all, it worked in the Classic client but not in the RoleTailored client. Sigh. Don’t you just hate that? It means going through the pain of debugging the RoleTailored client. The error was caused because the FieldRef.Value function for a FieldRef that points to an Option type field returns different values in the Classic client and RoleTailored client. If you want proof, try running this Codeunit in both the RTC and...
Filed under: , , ,
Creating New Windows Logins in NAV Through a SQL Sproc
Published 2011-7-23 11:02 | Gaspode
If you’ve been following my on-going battle against the pigs, you’ll be pleased to know that I now have attained three stars on all of the levels in Angry Birds Seasons, Angry Birds, and Angry Birds Rio, so with no more pigs to kill until the next update, I figured I’d write another NAV blog. One of the reasons I started blogging was to have a place where I could save little gems so they can be easily found later on. One of the directors at Intergen suggested that I blogged the information and then...
Filed under: , , , , ,
Make me squeal
Published 2011-6-20 23:07 | Gaspode
If God had wanted me to work, he wouldn’t have given me Angry Birds.   I figured it was about time I wrote something about Dynamics NAV again, so setting my continuing mission to get three stars on all levels to one side, I’ve finally taken time to pass on a couple of tips around .NET Interop and executing SQL Stored Procs from within NAV (I used to work with someone that pronounced SQL as “Squeal” instead of “Sequel” hence the title of this post). Way back in April (wow has it been that long...
Filed under: , , , , ,
20-30% Discount on Dynamics Books During May 2011
Published 2011-5-17 20:25 | Gaspode
Those people at PACKT have been busy making more and more books on Dynamics covering GP 2010, NAV 2009, AX 2009, and Sure Step, so whichever flavour of Dynamics you prefer, there’s something for you to get your teeth into. To celebrate the recent publication of the Microsoft Dynamics GP 2010 Reporting book, PACKT has announced a series of attractive discounts on their Dynamics books:   Buy any Microsoft Dynamics printbook and get 20% off Buy any Microsoft Dynamics eBook and get 30% off So if...
Filed under:
Execute SQL Command using .NET Interop
Published 2011-4-13 12:12 | Gaspode
OK, I’ll admit it, I’m obsessed with the .NET Interop features in NAV 2009 R2. My last two blog posts have been on this and now here’s another one. Today I wanted to see if I could use the .NET Interop features in NAV 2009 R2 to execute a SQL Stored Procedure and extract the results. I know you can do this using COM, but I figured it would be fun to try this using .NET. The great thing about .NET is it’s so well documented. My starting point for this exercise was to search...
Filed under: , , ,
.NET Interop—I’m Lovin’ It!
Published 2011-2-16 20:33 | Gaspode
If this was a blog about grammar, I might be asking whether a verb like “to love” can be conjugated in a progressive tense to give us the phrase “I’m Lovin’ It”. But it’s not, it’s a blog about Dynamics NAV and I’m writing about .NET Interop in Dynamics NAV 2009 R2 which has got to be the coolest feature for NAV ever! Let’s assume that you’re into Dynamics NAV and not dynamic verbs. The question I’m really asking here is how do you find the temporary path in Dynamics NAV? Easy, I hear your shout...
Filed under: , ,
Regular Expressions in NAV
Published 2011-2-2 19:32 | Gaspode
A friend of mine recently asked if there was a standard NAV function to find the first alphabetical character in a string. STRPOS comes close but you can't say "tell me the first position for any one of these characters in this string" because it looks for an exact match of the substring and not any character from the substring. The AL code to do this isn't hard but I figured this was a perfect excuse to play with the new .NET Interop feature in NAV 2009 R2. With the release of...
Filed under: , ,
Book Review: Microsoft Dynamics NAV 2009 Programming Cookbook
Published 2010-11-28 9:34 | Gaspode
Author : Matt Traxinger Publisher : PACKT ISBN : 978-1-84968-094-3 Published : October 2010 Long ago when I was co-writing Implementing Microsoft Dynamics NAV 2009 one of my colleagues said to me, “You don’t want to write a book like that, you want to write a NAV cookbook.” I must admit I hadn’t read any programming cookbooks and didn’t know what he was talking about so I just smiled and nodded reassuringly before totally ignoring him. Then, lo and behold, along comes a request from PACKT asking...
Filed under:
Creating a view across all companies–part 3
Published 2010-8-29 15:31 | Gaspode
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 that would dynamically create your view for all companies that exist in the database. In this final part, I’m going to show you how to link the...
Filed under: , , ,
Creating a view across all companies—part 2
Published 2010-8-22 17:12 | Gaspode
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 to create our view. What is Dynamic SQL? Dynamic SQL is when we use programming code to build up our SQL Select statement in a text variable and then...
Filed under: , , ,
Creating a view across all companies–part 1
Published 2010-8-15 2:31 | Gaspode
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 NAV. First of all, we need to cover some basics. NAV has the facility to create a table definition that is linked to a view in the database that has the...
You Could Win Visual Studio 2010 Ultimate + MSDN
Published 2010-7-25 13:02 | Gaspode
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 free! What do you need to do? As you know, Microsoft Dynamics NAV 2009 SP1 introduced a new feature called Control Add-ins. These are .NET controls...
More Posts Next page »