>>Hi,
>>
>>I have a column/field which is Logical in VFP and BIT (not NULL) in SQL Server. The segment of SQL Select statement dealing with this column looks like this:
>>
>>
>>where TABLE.Field1 order by <someother>
>>
>>
>>When executing this SQLSelect against SQL Server the error says:
>>
>>"Non-boolean type specified in context where a condition is expected, new 'order'"
>>
>>Do I understand that - for SQL Server backend - I must modify the SQL Select to have this column as TABLE.Field1 = 1 ?
>>
>>TIA.
>
>yes.
You can also do
where Table.Field1 = 'true'
If it's not broken, fix it until it is.
My Blog