We will be using delphi and mysql in a multiuser environment. Am i right in saying that if we set all of our tables to 'Type = InnoDB' that we will be assured of data integrity through transaction control?

We need to ensure that users at different terminals do not write over records that someone has just changed....

Many thanks