We have a web application using Gentle.NET 1.2.9 with MySql 5. There is also a legacy MS Access frontend which is making updates to the database. Unfortunately the Access frontend is inserting -1 for the boolean columns (these were actually converting to TINYINT when migrating from the old Access database). Gentle.NET (or maybe the MySql .net client?) is interpreting the -1 as FALSE instead of TRUE. Is there any simple way to have it intepret -1 as TRUE?
Thanks in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have merged code to fix this (Gentle should now interpret booleans stored as a fixed number using C/C++ logik, that is, zero is false and all non-zero values are true).
The code is untested and may not even compile properly (I just got my workstation back up from yet another Vista crash, and haven't had time to install VS yet), but it was a small change so there is hope ;)
You'll need to grab the latest source from Subversion to test it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We have a web application using Gentle.NET 1.2.9 with MySql 5. There is also a legacy MS Access frontend which is making updates to the database. Unfortunately the Access frontend is inserting -1 for the boolean columns (these were actually converting to TINYINT when migrating from the old Access database). Gentle.NET (or maybe the MySql .net client?) is interpreting the -1 as FALSE instead of TRUE. Is there any simple way to have it intepret -1 as TRUE?
Thanks in advance.
I have merged code to fix this (Gentle should now interpret booleans stored as a fixed number using C/C++ logik, that is, zero is false and all non-zero values are true).
The code is untested and may not even compile properly (I just got my workstation back up from yet another Vista crash, and haven't had time to install VS yet), but it was a small change so there is hope ;)
You'll need to grab the latest source from Subversion to test it.