Multiple Sql commands within a Trasaction.

Hi guys,

I'm new and still learning in Delphi. Can anybody help me regarding the correct syntax on executing multiple Sql commands(e.g. Insert) using Transaction? And if any statement fails, it will automatically rollback the transaction.

I would just add that, while Luthfi's technique is correct, the actual syntax will vary depending upon the database involved and the components used.
Some do not require an explicit start statement.
Some just require commit or rollback.
Firebird also has a CommitRetaining option, so just check your particular syntax.