Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disappearing ?
Message
 
 
To
24/10/2001 16:37:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00572896
Message ID:
00572920
Views:
22
This message has been marked as a message which has helped to the initial question of the thread.
You can use single or double quotes to fix this problem. My guess would be that SQL Select parser doesn't process string encloused in [] delimiters properly
Select ;
     "a?b" as Url ;
   From < table >
* or
Select ;
     'a?b' as Url ;
   From < table >
>On of our SQL statements has a field which contains a "?".
>
>I ran a simple test.
>
>
>Select ;
>     [a?b] as Url ;
>   From < table >
>
>
>The question mark disappears. Below fixes the problem.
>
>
>Select ;
>     [a] + Chr(63) + [b] as Url ;
>   From < table >
>
>
>I'm betting this has been documented already. What is the reason for this behavior?
>
>TIA
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform