Gerry, If you issue a START TRANSACTION in MySQL the current transaction gets automatically commited since it doesn't support nested transactions:
http://dev.mysql.com/doc/refman/5.0/en/implicit-commit.html This is not configurable. It could be a problem for TinyERP given its architecture. Here (http://dev.mysql.com/doc/refman/5.1/en/create-table.html) you can read: > The CHECK clause is parsed but ignored by all storage engines And this can't be overcome either with any configuration tweaks. But this are just a few "personality quirks" of MySQL. If it were a woman she would probably make a nice date but not someone to be the mother of my sons ;) Regards, Pedro _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
