Some years ago I wrote a series on validating data in NAV. The second post in this row, called Validating Data #2: Using VALIDATE, addressed the use of the AL function VALIDATE. From recent experience I would like to update some part of this post as this seems missing in any documentation on…
… unless your have a good reason for it! Already a year ago I wrote my Validating Data series. And only a couple of weeks ago me and my colleague were investigating one of our solutions that had a performance issue and were faced with code that wasn’t quite SMART with…
Although you might be aware now that any code in the OnLookup trigger will leave you as a developer to handle everything yourself, you have made the choice to write your own lookup functionality. As mentioned in my previous post OnLookup & OnValidate #1, you not only need to program…
I still recall, when I started using Role Tailored Client (RTC), that one of the things of that really surprised me was the error messages that appeared in the yellow ribbon. Well, it was actually not the message as such, or the yellow ribbon, it was more the fact that the…
Both a Dataport and XMLport object can be used to import data into Dynamics NAV. And as with user input and code entered data we might need to validate the data imported to impose the necessary business logic. This can be achieved in two ways: either by programming a VALIDATE after the…
If you read Validating Data #3: Cascading VALIDATEs you know by now that a VALIDATE call comes with a price. So where possible the programmer should diminish the number of VALIDATE calls. Or “… to avoid the validate statement when populating records …”, as Marije Brummel puts it in one…
In my post Validating Data #2: Using VALIDATE I addressed the issue of how to validate code entered data by using the field method VALIDATE. In my notes, however, I mentioned that a VALIDATE call comes with a price. This is what this post is about and how to make the cost…
Whereas validation of user input is one side of the medal, the other is validation of code entered data, the subject of this blog post. Code Entered Data Just as any user input code entered data should be validated before it is allowed to be recorded in the database. A…
Having seen a couple of posts on data validation coming by I decided to tackle this issue in a couple of blogs of which this one is the first. Just to straighten out me thoughts and knowledge on this, and share it with you. User Input Like in any other…