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 FIND functions in typical production code. While designing the code by using the MODIFY and DELETE record functions, we need to consider the 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 utilize the LOCKTABLE function to gain total control of the data briefly, while updating the data. We can find more information on LOCKTABLE in either the Developer and IT Pro Help or the MSDN online C/SIDE Reference Guide help. The SQL Server database supports Record Level Locking. There are a number of...