>>>My understanding that SQL Server BIT servers pretty much the same purpose as VFP Logical type column. If I have a table in SQL Server with a column type BIT and a table in VFP with the column type LOGICAL (basically the same-purpose table) can I use the same SQL Select or SQL UPDATE this column?
>>
>>>Is there a way to make both cases work with the same syntax?
>>
>>Either use a compiler constant or a global property set at app start depending on vfp/MsSQL usage...
>>If you use CA you could code this as a CA property...
>>Quite a lot of possibilities depending on your usage/deployments...
>>
>>regards
>>thomas
>

>Thank you, Thomas. I have not thought about compiler constant; will try it.

If you have an application object, I'd use that with properties .BoolTrue and .BoolFalse -
at first setting those values in code or via compiler constant. later on you could set perhaps via an ini or xml config file,
if your app is sent to different customers which can decide locally which backend to use.

my 0.001 EUR

thomas