Johnathan Revell's Personal Website
With Microsoft Dynamics Nav, there are various ways of viewing all the active sessions within the system. The easiest of which is the “Sessions” page within the software itself: The downside of this, is that it only shows active sessions […]
In remembrance for 100 years of the Battle of the Somme, local people and businesses donated towards lighting up Conisbrough Castle. The castle was lit up for 3 days, and raised well over £1500 for British Legion and the renovation […]
Within a recent project, I’ve been extracting data from Microsoft Dynamics NAV using Taskcentre. Within NAV, decimals are stored as decimal(38,20), complete will all 20 decimal places..! The following SQL query is very handy at removing the un-required decimal places […]
When using the “ODBC” or “OLEDB” tools in TaskCentre, it may appear that a single query is executed on the database. In actual fact from trial and error, I have identified multiple queries are being called. For example, if you […]
Today on Microsoft Dynamics Nav 2013R2, I kept getting the following error, which stumped me for a bit… Either the caller does not have the required permission or the specified path is read-only. After much investigation, I found a solution […]
Within MySql Workbench, there’s a feature called “Clean Up SQL” which automatically tidies up your SQL and the indentation automatically. This is a very useful feature, as your messy SQL then becomes nice and neat. Unfortunately with Microsoft SQL Server […]