hi..i'm a newbie in mysql. can anyone help me?how to do transaction on mysql with delphi. i was try with mysqloledb provider, but its not work. i recive message "the provider doesn't support ...". please help me.
thx..

mysql doesn't support transaction like stored procedure in ms sql.
John

greetings,
I've never used Delphi, always connect to MySQL using PHP, but transactions can be performed. There are two possibilities, either:
1. Use genuine transaction-safe ACID compliant tables such as InnoDB - http://dev.mysql.com/doc/mysql/en/InnoDB_overview.html
in conjunction with transaction syntax, BEGIN / ROLLBACK / COMMIT - http://dev.mysql.com/doc/mysql/en/In...rent_APIs.html
2. Use atomic operations with non-transaction-safe tables e.g. MyISAM - http://dev.mysql.com/doc/mysql/en/AN...nsactions.html

There are significant performance considerations but if you require full ACID compliance InnoDB is the way to go.

best of luck