>
>SQLEXEC(lnConnHandle,"SELECT @@VERSION as cData","cSQL")
>?cSQL.cData
>
>
>It works fine in VFP6 SP5, but in VFP7 SP1 & VFP8b I have to use the STRCONV() function:
>
>?STRCONV(cSQL.cData,6)
>
>
>Of course I can use casting in SQLServer & finally works in all versions:
>
>
>SQLEXEC(lnConnHandle,"SELECT CAST(@@VERSION as TEXT) as cData","cSQL")
>?cSQL.cData
>
>
>The Question is:
Why this change between versions?, Or how can I avoid casting?Actually, I'd say that it's working _better_ now than it was before. If SQL Server is returning Unicode, I don't want Fox to hide the fact - I want it to give me exactly what I asked for, and let me deal with it the way I think best.