Wednesday, November 30, 2016

How to use MARK and MARKED only function in MS Dynamics NAV 2017?

These 2 functions are similar to NAV Developer as we do use for Objects using CTRL +F1.


HERE is an example in which I had used to mark some records of Customer table with Starting Alphabet as "C" and with Location Code as "BLUE".


So Lets see the screenshot for reference :-



The Result is :-


Monday, November 21, 2016

How to INSERT a Record in Customer table and then modify that record?


Use OF AL to update insert delete in MS Dynamics NAV 2017?


We can insert a record and modify that inserted record into table using Codeunit.

For an Example: I am updating my name in Customer table and updating that Name.

Look at this Code.






After Running the Code-unit we got this desired result:-





Saturday, November 19, 2016

Bug Fix Needed on webSite of MSDN for query Function SAVEASCSV?


There is a function explained on MSDN website on this link SAVEASCSV for Query Object.


Syntax of Function :

QueryVariable.SAVEASCSV (FileName[, Format][, FormatArgument])
File Name is a text path where query will be Saved.
Format is a option field with 0/1 as parameters
0 means to provide length maually in FormatArgument between any 2 columns
1 means to provide in FormatArgument as , ; or 'tab' for space.

Bug No. 1


'tab' is not working with 1 as paramater it just copies the word tab in between coluum.
Bug No. 2
Microsoft has not written any example with 'tab'
Bug No. 3
Microsoft should notice that 'tab' is working with 0 and not with 1 as FORMAT parameter.
ScreenShot is attached below :-