>>>>Assuming a bit field (or numeric) where 1 = True and 0 = False:
>>>>
select iID, mylogical =
>>>> case
>>>> when llogical = 0 then 'Closed'
>>>> else 'Open'
>>>> end
>>>>from sometable
>>>
>>>This works fine in Query Manager but does not work in a remote view.
>>
>>Yes it does. What does it not do for you?
>
>It does not work in a VFP remote view.
Your original post led me to believe that this was a SQL Server remote view.
Did something change since then?
Wait a minute...
Are you using the View Designer?
If so, then you cannot create this view in the View Designer.
You must create it in code, e.g.
CREATE SQL VIEW YourViewName ;
REMOTE CONNECT YourConnection AS ;
select iID, mylogical = ;
case ;
when llogical = 0 then 'Closed' ;
else 'Open' ;
end ;
from sometable
Also, I apologize for leaving out the ";"s for the line continuation.
That may have thrown you off as well.
The select statement in a remote view must follow the syntax of the source database, but the coding structure (like with ";" as line continuation) still must follow VFP syntax.
Insanity: Doing the same thing over and over and expecting different results.