Photo credit: Dunechaser
Whilst implementing a hotfix for a well known UK payroll solution for NAV, I came across a new field which had been added to a table.
Nothing too unusual about that, but the name of this field half made me smile, and half made me think it was quite inappropriate. Continue Reading →
Photo credit: baldiri
If you’ve ever copied and pasted a list of objects from Object Designer into Excel, you’ll know that the object types are represented in their numeric form, e.g., Table=1, Form=2 and so on.
I tend to keep a spreadsheet of objects associated with changes I make for customers and so hop into Excel quite frequently to paste in sets of objects.
To save myself the time of manually converting the integer values to their respective object descriptions, I used a VBA macro stored in the spreadsheet to do the job.
All well and good, but it just wasn’t funky enough!
So I hacked together a quick Add-In for Excel 2007 to do the same job.
The advantage of using an Add-In is that it is easily distributable and can be given its own tab and button on the Excel Ribbon.
Once the add-in has been enabled in Excel, clicking the Convert Object Types button will do the conversion and make the Type column nice and readable.
I do have some other VBA bits and pieces lying around for manipulating Object Desinger data which I will probably include in this Add-In at a future date, as the single button does look a bit lonely 
If you’d like to try it for yourself you can grab the Add-In using the link below.
All you need to do is save the file to a suitable location and enable it as an Add-In from Excel Options.
Let me know in the comments if you find it useful.
Photo credit: zoomzoom
When you select a key by filling in the DataItemTableView property on a report DataItem, the request form is no longer shown.
How can we make it visible again? Continue Reading →
Photo credit: amortize
Enter a single question mark in any editable Text or Code field, then tab away from the field.
The Standard Text Codes form will be launched and you can select a text.
The code which makes this happen can be found in Codeunit 1 in a function called MakeText.
You could in theory hijack this function and code your own escape characters for your own purposes.
Photo credit: incurable_hippie
Okay, so we all know that we’re not privy to many bells and whistles when it comes to C/SIDE.
It’s a big thing then, when an innovation comes along which shakes the dust from years of neglect.
Well… color me badd, syntax highlighting in NAV 2009 has come to sex us up!
Try opening your favourite Codeunit (come on, I know you have one) in NAV 2009 and witness the glorious technicolor goodness for yourself.
There is a bug, or omission if you like, which means that block comments, denoted by curly brackets are not highlighted in green as they should be.
An earlier bug in the technical previews where the Documentation trigger would also be highlighted does seem to have been addressed though.
IF YourHappyAndYouKnowIt THEN
ClapYourHands;
It is sometimes a little disappointing that we don’t see more additions or attention to the development environment.
And we can probably count the major goodies that we’ve had on the fingers of one hand: Syntax highlighting in 2009, code indenting in 5.0, then going back even further, ability to search code , including function names in version 3.7
Some may argue for a more modern development environment.
I actually still really like the stripped down way we write and develop in C/AL.
Next,
