Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I...
Message
From
07/11/2000 14:59:44
 
 
To
07/11/2000 14:45:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00438565
Message ID:
00438967
Views:
9
>>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform