Page 1 of 1

help needed please!... Asboolean issue

Posted: Wed 07 Mar 2012 17:14
by Willo
I've reading all the post related to this, but im still confused. When i was using MyDAC 3.55 everything was working perfect. Now, that i bought the las version i got many errors on my code.

It seems im being able to solve most of it, but i cant figure how or what i need to change in order to use ASBOOLEAN field types.

I changed mysql structures from BIT to TINNYINT, doesnt work, i set EnableBoolean option to true and then back to false, neither one works.

So im desperate, how can i make this work?

Posted: Mon 12 Mar 2012 03:16
by Justmade
MyDAC, when set EnableBoolean = True, Use TinyINT(1) (i.e. Precision set to 1) as Boolean Field.

So you have change the field not only to TinyINT, but TinyINT(1).

Posted: Mon 12 Mar 2012 09:54
by AndreyZ
Justmade is right, you should use the TINYINT(1) data type in your tables. If the EnableBoolean property is True, MyDAC maps TINYINT(1) to TBooleanField.