AsInteger TinyInt(1) not possible

[Thomas J.]

I cannot acces the field value by using AsInteger. The field type is TinyInt(1) MySQL. The MySQL component are working with EnableBoolean=false.

How can access the int value?

Thanks Thomas

[Dimon]

I can not reproduce the problem.
Please make sure that the EnableBoolean option is set to False.
If this still does not solve the problem, please send me a complete small sample to dmitryg*devart*com to demonstrate it including a script to create and fill table.

[Thomas J.]

Sorry, but where can I find this option?
In MyDAC i could use in Option->EnableBoolean but in UniDac I don't see such option.

Thanks
Thomas

[Dimon]

You should use SpecificOptions. It provides extended settings for each data provider, like this:

Code: Select all

UniQuery1.SpecificOptions.Add('EnableBoolean=False');