SQL structure Help

Wonder Fef wonderfef at noos.fr
Tue Jan 21 13:34:23 CST 2003


Hello,

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 ' ?

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...

Thanks in advance for your help.
Eric



More information about the Valentina mailing list