-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
It's been a while since I last made a post and there are a few reasons. Bejweled Blitz on the iPhone is a big part, but also, it seems that there has been a real period of consolidation for me just recently: taking a lot of the things I learnt and applying them on projects, so not a lot of new stuff...
-
I recently tried using UPLOADINTOSTREAM to load a file from the RoleTailored client into a temporary file on the NAV Server so that I could then process it. This is needed in NAV 2009 because it has three tiers and the tier on which the code executes does not necessarily have access to the files that...
-
In the RoleTailored client on a Page, the xRec does not contain a record when you are inserting new records into a sub page. Previously if you wanted to know where you had pressed F3 to insert a line you could take a look at xRec and would know which line you were on when you pressed F3. Unfortunately...
-
NAV Supports various data types for parameters to functions, one of which is an Option. An option data type is stored internally as a number but will appear on screen, in reports as text. In other systems this is referred to as an enumerated type. Option type fields make it easy to write self-explanatory...
-
Author: Michael Badger Publisher: PACKT ISBN: 978-1-847196-76-7 Published: July 2009 Available from: http://www.packtpub.com/scratch-1-4-beginners-guide/book/mid/130709v31a3s I read recently that when writing for the web, you need to get to the point quickly because ‘Generation Y...
-
I was on the PACKT web site the other day and I noticed that David Studebaker has written an update to his book on Programming Microsoft Dynamics NAV. I knew David was thinking about updating his book but had no idea it was so close to being finished. You can pre-order the book now by visiting the PACKT...
-
I remember the first program I wrote. It was with my brother, Mike, on his Sinclair ZX81. We made a simple game in which a parachutist dropped from the sky and had to land on a platform. The platform appeared in a random position and the player could move the parachutist left and right as he dropped...