>>>What is the equivalent of :
>>>select .f. as f_logic, af1, af2 from myTable
>>>
>>>in sqlexce
>>>
>>>sqlexec(nhandle," select .f. as f_logic, af1, af2 from myTable ", "ccur")
>>
>>It should work for VFP ODBC driver. What backend database are you running against?
>
>sqlExpress 8.
>Chuck Mautz answer it
>thanks
MS SQL Server does not have logical data type. A bit is numeric data type. It works in this case because VFP maps the bit data type to VFP logical field.
--sb--