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]
<mailto:[email protected]> .
To post to this group, send email to [email protected]
<mailto:[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.
