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.
