Dave's Blog

Service Tier and Classic Client Monstrous Nightmare with FieldRef

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...

Published 08-12-2011 9:49 p.m. by David Roys

Filed under: Programming, Gotcha, Tip, NAV 2009 R2

Creating New Windows Logins in NAV Through a SQL Sproc

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...

Published 07-23-2011 9:02 p.m. by David Roys

Filed under: Programming, NAV 2009 SP1, NAV 2009, Tip, SQL, NAV 2009 R2

Make me squeal

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...

Published 06-20-2011 10:07 p.m. by David Roys

Filed under: .NET, Programming, Gotcha, Tip, SQL, NAV 2009 R2

20-30% Discount on Dynamics Books During May 2011

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...

Published 05-17-2011 7:25 p.m. by David Roys

Filed under: Book News

Execute SQL Command using .NET Interop

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...

Published 04-13-2011 10:12 p.m. by David Roys

Filed under: .NET, Programming, SQL, NAV 2009 R2

.NET Interop—I’m Lovin’ It!

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...

Published 02-16-2011 9:33 p.m. by David Roys

Filed under: .NET, Programming, NAV 2009 R2

Regular Expressions in NAV

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...

Published 02-02-2011 8:32 p.m. by David Roys

Filed under: .NET, Programming, NAV 2009 R2

Book Review: Microsoft Dynamics NAV Administration

Authors: Sharan Oberoi, Amit Sachdev Publisher: PACKT ISBN: 978-1-84719-876-1 Published: September 2010 Once upon a time you couldn’t get books on Dynamics NAV for love nor money, then in October 2007 PACKT published David Studebaker’s book Programming...

Published 12-31-2010 4:18 p.m. by David Roys

Filed under: Book Review

Is there anybody out there?

Way way back in July I ran a competition to give away 2 Microsoft Visual Studio 2010 Ultimate with MSDN subscription cards. I said I would announce the winners in September, but didn’t. You see the thing is, the response was pathetic. Only one entry who...

Published 11-28-2010 11:07 a.m. by David Roys

Book Review: Microsoft Dynamics NAV 2009 Programming Cookbook

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...

Published 11-28-2010 10:34 a.m. by David Roys

Filed under: Book Review

Creating a view across all companies–part 3

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...

Published 08-29-2010 2:31 p.m. by David Roys

Filed under: Programming, NAV 2009 SP1, NAV 2009, SQL

Creating a view across all companies—part 2

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....

Published 08-22-2010 4:12 p.m. by David Roys

Filed under: Programming, NAV 2009 SP1, NAV 2009, SQL

Creating a view across all companies–part 1

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...

Published 08-15-2010 12:31 p.m. by David Roys

You Could Win Visual Studio 2010 Ultimate + MSDN

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...

Published 07-25-2010 12:02 p.m. by David Roys

Action Images

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...

Published 06-22-2010 10:55 p.m. by David Roys

Syndication

Recent Posts

Tags

Archives

Action Image Tag Cloud