Devart Forums

Im trying to generate a ftBoolean field, but the field i got is ftLargeint, how i should do it?

this is my query:

Select sl_pol,sl_aseg,sl_num,sl_cia,sl_tipo,re_num,re_cant,
(re_record='G') as seleccionado,re_mon,re_end
from polizas inner join recibos on re_pol=sl_pol

seleccionado is the field in question.

TIA

I guess that you mean the seleccionado field.
There is no possibility to determine that this field is a boolean field because MySQL server does not provide enough information for that. That is why MyDAC considers such fields as TLargeInt fields.