>Hi!
>
>Let's say I want to delete multiple records from some buffered related tables, but the commands fails. What should I do in this case in order to avoid any unexpected problems in my app?

More or less the same as with any other modification. Here is an example of getting information, in a form. A single record is deleted.

delete
if TableUpdate()
  skip
  ThisForm.Refresh()
else
  local laError(1)
  aerror(laError)
  MessageBox("Error deleting. Error #" + transform(laError(1));
    + " Message " + laError(2))
endif

Now, what do you do when you delete several records, and it fails? You must decide what is appropriate for the logic of the application.

For instance, you can continue deleting all the records you can, and show the user a list of records that can't be deleted.

Another possibility is to delete "all or nothing" - if you can't delete one record, undo everything. This, you would do with transactions.