✏️ Explanatory Question
Difference between update and update_recordset: update is used to update a single record, while update_recordset can update multiple records in a single operation:
CustTable.Name = 'New Name';
update CustTable;
update_recordset CustTable setting Name = 'New Name' where CustTable.Country == 'US';