In the previous chapter, we learned a little about the basics of the
FIND function. We learned about
FIND('-') to read the beginning of the selected records and
FIND('+') to begin reading at the far end of the selected records. Now we will review additional functions that are generally used with
FIND in typical production code. While designing the code by using the Modify and Delete record functions, you 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 in which your application is working.
You will likely want to utilize the
LOCKTABLE function to gain total control of the data briefly, while updating the data. You can ...