ODBC driver doesn't like columns named PASSWORD

Support information related to Pervasive SQL Databases

ODBC driver doesn't like columns named PASSWORD

Postby Bob Cergol » Wed Aug 01, 2012 9:37 pm

When I click on a table that contains a column named "PASSWORD" I get this error:
PSQL_Column_Name_Error_Pasword.png (17.3 KiB) Viewed 40653 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 40653 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.

User avatar
Bob Cergol
Certified Dynamic AI Professional
Posts: 359
Joined: Fri Dec 11, 2009 5:48 pm

Return to Pervasive SQL