Thank you so much. You're right. Thanks, again Goran Regards El jue., 28 mar. 2019 a las 23:54, <[email protected]> escribió:
> Try: (note the extra ‘ chars added in yellow) > > CALL CSVWRITE > > ( '/home/gb/carrier.csv', > > 'SELECT NAME FROM CARRIER WHERE NAME = ''what ever you want''', > > 'fieldSeparator=;' > > ) > > > > That is add an extra ' Is you have quote string inside a quoted string… > (escaping the quote char) > > So if I would insert a string “That’s it”, You would have to do do: insert > into t1 values(‘That’’s it’) > > > > /Goran > > > > *From:* [email protected] <[email protected]> *On > Behalf Of *Marving Jr > *Sent:* 28 March 2019 18:10 > *To:* H2 Database <[email protected]> > *Subject:* [h2] CSV WRITE > > > > I'm trying use CSVWRITE with quote inside query, but i can not get it > > > > > > CALL CSVWRITE > > ( '/home/gb/carrier.csv', > > 'SELECT NAME FROM CARRIER WHERE NAME = 'what ever you want'', > > 'fieldSeparator=;' > > ) > > [Exception, Error code 42.001, SQLState 42001] Error de Sintaxis en > sentencia SQL > > > > > > Also with oduble quotes > > CALL CSVWRITE > > ( '/home/gb/carrier.csv', > > 'SELECT NAME FROM CARRIER WHERE NAME = "what ever you want"', > > 'fieldSeparator=;' > > ) > [Exception] > Column "what ever you want" not found; SQL statement: > > > Can somebody help me? > > Regards > > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
