I have this (relevant snippets only):
Code: Select all
on BeginTrans DBID put "Start Transaction;" into StrSQL revExecuteSQL DBID,StrSQL get the result --#debug end BeginTrans => result "0" --[1 SELECT & 1 INSERT statements here, that work] --[now I want to know if can roll back:] On RollbackTrans DBID put "Rollback;" into StrSQL revExecuteSQL DBID,StrSQL get the result --#debug -- get revdb_rollback(DBID) end RollbackTrans => result "0", or empty in the commented version
I don't get any MySQL errors (as happens if I send a wrong SQL), I don't get any LC errors, it just writes the data, but refuses to roll back.
What I'm doing wrong? MySQL is 5.6.21
I'm sure it's another stupid error, thx for any help!
Edit & Solution:
The MySQL is MyISAM, and this doesn't support transactions ...