![]() |
MS Query does not quote identifiers in the generated SQL
Out users need to analyze data in a Postgres database. The Schema, table,
and field names are all in UPPER case. After selecting the particular datasource, MS Query Wizard correctly presents the tables, and upon choosing a table correctly displays all the fields. After choosing the desired fields, and then executing the query, a tombstone appears saying 'Error: Schema "scott" does not exist'. This is true because the name is "SCOTT" not "scott". If I manually type the SQL, and include the appropriate quotes, the select works fine. I have tested this with both Excel 2002 and Excel 2007 with the same result. Is there a way to cause the MS Query Wizard to fill in the appropriate quotes? Is there another workaround? |
All times are GMT +1. The time now is 02:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com