Monday, November 14, 2016

HOw USE OF FINDSET in MS Dynamics NAV 2017?.

How to use FINDSET



As per MSDN,Findset gets the records on the basis of filters applied over the record type.
If now filters are applied then we can use it to update all records present in table using REPEAT UNTIL.

I had defined these two variables in navision.

DIFFERENCE between FINDSET,FINDFIRST,FINDLAST in NAVISION.

FINDSET :- It retrieves 50 records in tables and update it one by one.
FINDLAST :- It points to LAST Record in a DATASET Filter.
FINDFIRST :- It points to FIRST Record in DATASET FILTER.



Following is the code which I had written to get the processed data in a table.




This is the desired result:













No comments:

Post a Comment