>>>Hi,
>>>
>>>I have an expression that works SQL Server DB:
>>>
>>>select CAST(0 AS BIT) AS MYFIELD
>>>
>>>
>>>Of course the above will not work for VFP. Is there a way to change the expression above that it would create a calculated logical field in VFP as well as SQL DB?
>>>
>>>TIA
>>
>>I believe this works in SQL Server (not tested) and for sure in VFP:
>>
>>SELECT 1=2 AS MyField
>>
>>In MySQL this syntax does not work. I usually refrain from creating boolean fields in the database and prefer single digit numeric values instead (0=false, 1 = true). In MySQL you cannot cast to bool (although the data type exists) and SQL Server boolean datatype does not exist.
>
>Thank you. I decided to have two separate expressions, one for SQL and one for VFP.
I found another alternative:
PRIVATE plValue
plValue= .F.
Select ?plValue AS MYFIELD
Christian Isberner
Software Consultant