Page 1 of 1

ODBC driver doesn't like columns named PASSWORD

PostPosted: Wed Aug 01, 2012 9:37 pm
by Bob Cergol
When I click on a table that contains a column named "PASSWORD" I get this error:
PSQL_Column_Name_Error_Pasword.png
PSQL_Column_Name_Error_Pasword.png (17.3 KiB) Viewed 38433 times


The log indicates a syntax error in the SQL with an error code shown after this column:
PSQL_Column_Name_Error_Pasword2.png
PSQL_Column_Name_Error_Pasword2.png (28.9 KiB) Viewed 38433 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