Get syntax error when running a query using CSV connection (149789)
Get syntax error when running a query using CSV connection
While connected to a CSV file, if a query is run that includes a column whose name begins with an underscore, the following error is returned.
[Microsoft][ODBC Text Driver] Syntax error in query expression '_empno'
Put double quotes around the column name that begins with the underscore.
select _col1 from table1;
select "_col1" from table1;
© 2021 Quest Software Inc. ALL RIGHTS RESERVED.