[V4RB] Strings...

[Deane Venske]

Ruslan Zasukhin wrote:

>on 9/15/03 2:57, Deane Venske at dean at eduss.com wrote:
>
>Hi Deane,
>
>  
>
>>This is not really a problem, but rather an inconsistency that being a
>>developer I know probably has a good reason but I thought I'd bring it up.
>>When using strings with apostrophies in them, such as O'Grady, I user
>>double quotation marks to insert them :
>>INSERT INTO userDetails VALUES(1, "Charles", "O'Grady")
>>This works fine. But when I'm trying to do a select this query doesn't
>>work :
>>SELECT FROM userDetails WHERE lastName = "O'Grady"
>>Instead I must use a forward slash to complete the query like this :
>>SELECT FROM userDetails WHERE lastName = 'O\'Grady'
>>    
>>
>
>  
>
>>Any double quotes don't work in SELECTs but do in INSERTs. I'm currently
>>using V4RB 1.9.8 released on July 31st.
>>    
>>
>
>In the new SQL parser we will have only single quotes for string constants,
>as this require SQL 92 standard.
>
>But may be we will add also feature as in mySQL that allow do
>    "str'ing" 
>    'str"ing'
>
>
>  
>
>>I'm not sure if anyone has managed to compile the V4RB Client into a
>>Real Basic 5 plugin, but if they have would it be possible to get that,
>>or perhaps get instructions on how to do it, what files to put where etc.
>>    
>>
>
>I will make new archive for you right now.
>On download beta page will be new link to V4RB_Client RB 5.0 format.
>
>  
>
Ruslan, you are the best! I look forward to a long relationship with 
Valentina!

Deane