>>>I need to add an analog of VFP logical field to Sybase table through SQL Anywhere. Can anybody tell me what data type I need to choose?
>>>It seems to be BIT data type, but in VFP remote view I see it converted into INTEGER.
>>>
>>>Nick
>>
>>Hi, Nick!
>>Did you try to use DBSETPROP() to reset DataType property?
>
>Hello Edward,
>
>Yes, I tried, it works for the view ( I mean the property is changed), but when I try to browse the view, I get the error message:
>"Type conversion required by the DataType property for field MyField is invalid"
>
>So, I mean - what data type at the back end is the closest analog to VFP logical field?
>For now I just use that integer field with values 0 and 1, but I would like it to be .F. and .T.

At last I figured out, that TinyInteger data type is the more suitable for that. It converts OK. :)