ODBC driver doesn't like columns named PASSWORD
Posted: Wed Aug 01, 2012 9:37 pmWhen I click on a table that contains a column named "PASSWORD" I get this error:
The log indicates a syntax error in the SQL with an error code shown after this column:
You also cannot use this column in a dyn-view even if you caption it as something else. It looks like the ODBC driver simply cannot select on a column named "password".
Lucklily I will never need to report that column for this client, but users who attempt to use such tables, or dyn-joins where that column would be auto-selected in the first 50 for details may not so easily spot the problem as I did.
Bob
- PSQL_Column_Name_Error_Pasword.png (17.3 KiB) Viewed 45197 times
The log indicates a syntax error in the SQL with an error code shown after this column:
- PSQL_Column_Name_Error_Pasword2.png (28.9 KiB) Viewed 45197 times
You also cannot use this column in a dyn-view even if you caption it as something else. It looks like the ODBC driver simply cannot select on a column named "password".
Lucklily I will never need to report that column for this client, but users who attempt to use such tables, or dyn-joins where that column would be auto-selected in the first 50 for details may not so easily spot the problem as I did.
Bob