SQL structure Help

[Ruslan Zasukhin]

on 1/21/03 2:34 PM, Wonder Fef at wonderfef at noos.fr wrote:

Hi Wonder,

> I'm importing a text file into a vdb database.
> I use a SQL statement like :
> 
> INSERT INTO myTable (Field1, Field2, Field3) VALUES ('Value1', 'Value2',
> 'Value3')
> 
> It runs great excepting that Valentina refuses to insert a record if one of
> its value contains a "\" character.
> 
> Moreover, how can I insert a field which contains a ' ?

You have 2 ways:

1) escape it
            INSERT INTO T (f1) VALUES ('Brian\'s book')


2) use double quotes, yes they work in INSERT
            INSERT INTO T (f1) VALUES ("Brian's book")

Second way probably more effective.



What means refuse with \  ?
It remove this character ?
Or totally refuse ?


> I think that some characters are used for the SQL syntax, so that a bad use
> of them leads to errors, but there must be a workaround...

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------