database.starttransaction
try
  do something
  ...........
  database.commit
except
  database.rollback;
end;