Book Image

Programming Microsoft Dynamics NAV 2015

Book Image

Programming Microsoft Dynamics NAV 2015

Overview of this book

Table of Contents (19 chapters)
Programming Microsoft Dynamics™ NAV 2015
Credits
Foreword
About the Authors
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Input and Output functions


In the previous chapter, we learned about the basics of the FIND function. We learned about FIND('-') to read from the beginning of a selected set of records, FINDSET to read a selected set of records, and FIND('+') to begin reading at the far end of the selected set of records. Now we will review additional functions that are generally used with the FIND functions in typical production code. While we are designing code which uses the MODIFY and DELETE record functions, we need to consider possible interactions with other users on the system. There might be someone else modifying and deleting records in the same table which our application is updating.

We may want to use the LOCKTABLE function to briefly gain total control of the data, while updating the data. We can find more information on LOCKTABLE in the online C/AL Reference Guide Help. The SQL Server database supports Record Level Locking. There are a number of factors that we should consider when coding data...