So, you need to retrieve from the database all customers with the Name = ‘John’ OR the Email = ‘[email protected]’ in order to make something with each record from the resulting dataset. In other words you need to use a Multicolumn OR filter. What is the best way to do this in NAV? Please do…
Vjeko, wrote some very good posts about the bad performance of COUNT function used in Microsoft Dynamics NAV. You can check them out at the end of this post. COUNT function can be used in NAV to find out how many records with certain filters you have in the database. Let’s take a simple example…
The Overtime Tracker is an application developed in Access 2013. It was designed to store and analyze the Overtime hours submitted and compensated by the employees of one client. This app can be modified and in the real environment it is updated with more modules and features in order to satisfy multiple needs of the HR…
The part 2 of the post which shows how to create a simple application with Windows Forms interface and SQL Server Database
A very easy tutorial about how to create in Visual Studio and SQL Server a simple application