mardi 23 février 2016

Firebirdexport - How to deal with column names that look like keywords

As the title says, how am I going to deal with a column name in FBExport that look like a keyword?

this is how my statement looks like:

-Q "SELECT a.ID, a.USERID, a.`WHEN`, a.INOUT FROM ATTENDANT a"

then I get this error:

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 26
WHEN

When I use

"WHEN"


Error: Switches must begin with -

tried 'When'

-Q "SELECT a.ID, a.USERID, a.'WHEN', a.INOUT FROM ATTENDANT a;"
SQL Message : -104
Invalid token

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 26
'WHEN'

Error: Switches must begin with -

anybody know the correct escape characters?

regards,

Florian

Aucun commentaire:

Enregistrer un commentaire