I've got a new problem whit mysql (InnoDB tablespace)....
Windows 2000 Pro. SP2,
MyODBC 2.50.39 (nt-2000 Installation),
MySQL 3.23.47 (mysqld-max-nt as service),
MS Visual Studio 6 Enterprise.
I'm developing an application with MS VC++ and InnoDB works finely...
There's only ONE problem: TRANSACTIONS (begin/commit/rollback) are not running from the application but only from command prompt client.
In Visual C++ I'm using CDatabase and its ->Begintrans() and ->CommitTrans() methods.
I've tried this:
where db is a CDatabase object and SQL is an INSERT INTO statement.
Whell, the transaction in not rolled back!