I'm using MySQL for quite some time now and would like to use transaction support (InnoDB) from Delphi right now.
The Database itself is setup correctly (I can use transactions from the command line client -> Begin -> ... -> Commit), so maybe this is a little offtopic.. But I'm kind of lost right now.
Using the standard Delphi Query-Components (TSQLQuery) I try to issue the same commands as on the command line.. In spite of all my tries everything is instantly committed to the database tables.