Ruslan Zasukhin wrote:
>on 9/15/03 2:57, Deane Venske at dean at eduss DO.T 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
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2003 Deane Venske |
