help needed please!... Asboolean issue

Willo · Post by **Willo** » Wed 07 Mar 2012 17:14

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?

Justmade · Post by **Justmade** » Mon 12 Mar 2012 03:16

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).

AndreyZ · Post by **AndreyZ** » Mon 12 Mar 2012 09:54

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.