Page 1 of 1
Error in version 5.20
Posted: Fri 01 Feb 2008 20:36
by cybsistemas
Myquery1.SQL.Text := 'select *,false as pago from gastos'.
In that example the fiel pago is LargeInt (error) When in reality is Boolean
In version 5.10 working correctly in 5.20 no.
Posted: Mon 04 Feb 2008 14:03
by Dimon
Yes, you are right. We added mapping of boolean constants to TBooleanField in MyDAC 5.10.
But it also caused mapping of such integer constants as 1 and 0 to TBooleanField. After some deeper investigation we found out that MySQL server returns the same result for both queries 'SELECT FALSE' and 'SELECT 0', and there is no way to ascertain which of queries was executed. Therefore we had to rollback this fix in one of the subsequent builds.
Posted: Mon 04 Feb 2008 14:56
by cybsistemas
Thank you