Aleksey
Thank you so much. It seems I have to convert the datatype in SQL Server, giving up using 'bit' and switching to Integer. I have to keep mssql and mysql database synchronized, so I think that's the way.
Thanks again.
>
>Take a look into "Data Type Conversion Control" topic in VFP8 help. It says that you can not do this on VFP side, but you can force SQL Server to return integer field by performing conversion on its side.
>
>>I can't post a repro code, because I did all those things in Command window.
>>
>It is not like I still need a repro. But, doesn't copy/paste works in Command window?
>
>Thanks,
>Aleksey.
Grigore Dolghin
Class Software.