23 May
2007
23 May
'07
5:09 a.m.
Hello,
You assume here that auto-commit is re-enabled when the statements fall outside the transaction brackets. The mode change and the consequences should be clearly documented in Mapi. It may indeed be useful to fall-back to auto-commit outside explicit transaction boundaries.
regards, Martin
It is indeed a "SQL style error" to forget the start transaction + commit around some statements. But the same script runs fine in mysql, postgres and sqlite. Would it be possible to fall-back to auto- commit, or to generate an error message? Monet behavior is not intuitive, and it would be hard to find in the documentation. BR, Alex