File.QUERYREPLACE in NAV2009R2

I noticed some strange behaviour of NAV2009R2 with QUERYREPLACE (of course with File=>Database=Alter=>tab Options=>Enable for Microsoft Dynamics NAV Server=TRUE):
file.QUERYREPLACE(FALSE);
=> gives a warning "Function ‘QUERYREPLACE’ is obsolete for Microsoft Dynamics NAV Server.". Nice! I don’t want to have an error when running in the NAV-servicetier, so I will fix my code.
IF (NOT ISSERVICETIER) THEN
file.QUERYREPLACE(FALSE);
=> does NOT […]

I created a new page, put some fields on it but they don’t appear in the Windows client

I also restarted the service tier, but still the same problem. And the preview shows the new fields!
Why?
Probably in your personalized settings, there is some leftover that hides the fields.
Solution:
Go to "Customize this page" and where you see "Restore defaults", click it (there are multiple ones and I didn’t check out which one exactly does […]

Zoom aka "About this page" in NAV2013

The "About this page" is very handy to have some info about the page and the table of that page.
But it doesn’t work on a subpage. If I select "About this page", it always shows me the info of the main page.
It is possible to do it, and it is quite easy too : When […]

Form/Page - OnNextRecord-trigger

Ever happened that your form/page does not show records (or only one) and you are sure that it works on the real table and you don’t have ANY filters (nor by code, nor by properties) on it?
IF yes THEN
Continue reading
ELSE
Continue reading anyway!
Generally it is because you have some code in the above-mentioned trigger (and also […]

OnDatabase-triggers in codeunit 1

First a small introduction for those who don’t know the OnDatabase-triggers yet.
In the beginning (don’t worry, this not a fairy tale, but it is some history), there were only the "OnGlobal"-triggers in codeunit 1.
But these had a small problem. They were only called when a user changed data. It did not intercept changes done by […]

NAV Techdays 2013

I know, already 2 weeks have gone since the event, but I have been more than busy these 2 weeks.
This is the first day I have some time to sit behind my computer not having to work on urgent things. (It is weekend AND I have time to get behind a computer.)
Enough rambling now. Let’s […]

Microsoft Dynamics NAV 7 Programming Cookbook bis

The book starts with an overview of the different datatypes and examples on how to use them.
Then we go to the basic statements like IF, FOR, WHILE, functions, parameters. When I started with NAV, I never found good info on how to use those. It was a trial-and-error experience. With this book, this is a […]

Microsoft Dynamics NAV 7 Programming Cookbook

I have never seen so many books published about a Microsoft Dynamics NAV version (or before Navision with its varied arsenal of names) as there are for NAV 2013.
Now I have Microsoft Dynamics NAV 7 Programming Cookbook on my shelf to read and learn (there is always something to learn!).

NAV TECHDAYS 2013: what are the interesting sessions to follow?

Why did I want to write this? So you don’t lose time selecting the sessions yourself.
Here is my list:

How to use multiple licenses simultaneously in service tier and development (and classic) environment?

What problem do we want to solve?
A partner has multiple databases (at least 1 per customer) and wants to use, at the same moment, the developer license for development and also the customer license for testing. At the moment, this is quite difficult to do (except creating multiple databases).The same problem is at the customer […]

Create a new blog and join in the fun!