Transactions with datasnap, dbexpress and mysql

[Adrian Mercieca]

Hi,

Does anyone know if the codegear dbexpress driver for mysql works well
with transactions?

Are they supported at all?

Reading the TransactionsSupported property returns true, but when I did
a test to invoke a stored procedure that updates some tables from within
a datasnap application, the subsequent rollback call I'm doing (for
testing purposes) is failing completely - the updates are still
committed to the database despite calling StartTransaction on the
connection before invoking the stored procedure and then calling
Rollback when the stored proc returns!

Any clues?

Tks - Adrian.