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