In the previous chapter, you learned about the basics of the FIND function. You 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 FIND functions in typical production code. While we are designing code that 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 that our application is updating.

We may want to utilize the LOCKTABLE function to gain total control of the data briefly while updating it. We can find more information on LOCKTABLE in the online C/AL Reference Guide Help. The SQL Server database supports...