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...