CRUD record methods
CRUD (Create, Read, Update, and Delete) methods form the basis of interacting with the Microsoft SQL server. In the previous chapter, you learned about the basics of the Find* methods, which represent the “Read” part in CRUD. You learned about FindSet and Find('-') to read from the beginning of a selected set of records, as well as Find('+') to begin reading at the far end of the selected set of records.
Now we will review additional CRUD methods that are generally used in typical production code. While we are designing code that uses the Modify and Delete record methods, 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 Record.ReadIsolation method to gain total control of the data briefly while updating it, referred to as locking. We can find more information in...
