STRICT_MODE can be set by the client and ignored by the server... In fact we could make the server ignore even the date checking constraints from the client setting the ALLOW_INVALID_DATES parameter regarless on how the server is set to work.
But there are many more issues. Some of them would affect TinyERP like MySQL quietly ignoring CHECK constraints set on the table definition, the implicit commits of certain transactions which would make it impossilble to rollback, truncations on certain inserts, etc. Data integrity is not the main issue for MySQL. It is something you have to try to achieve setting the proper storage engine, setting the proper parameters (and hope that the client app doesn't change them for their session) etc, etc, etc. We have to use MySQL on everyday basis. We think it is the right tool for some applications. I just think it's not the right tool for an ERP. Regards, Pedro _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
