[V4RB] Strings...

[Ruslan Zasukhin]

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.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------