Hi,
When pressing the content tab I get very often an error (exception) caused by "-" in field or table names.
I got this feedback from the JDBC driver/database support:
The error is happening because of the table names tbl.Bh-Status and tbl.Uid that should be tbl."Bh-Status" and tbl."Uid" in the SQL query used and generated by SQuirrel SQL for previewing the data in the 'Content' tab.
If I add the double quotes (tbl."Bh-Status" and tbl."Uid") to the 2 tables causing the SQL syntax error then the SQL query succeed:
Unfortunately I did not found an option in SQuirrel SQL that would automatically add double quotes around all the table names for previewing data in the content tab.
Stefan
==================================
Hannover Rück SE, Handelsregister (Commercial Register) Hannover HRB 6778 / E+S Rückversicherung AG, Handelsregister (Commercial Register) Hannover HRB 6117; für beide Gesellschaften gilt (applicable to both companies): Karl-Wiechert-Allee 50, 30625 Hannover, Germany; Sitz (registered office) der Gesellschaften: Hannover; Aufsichtsrat (Supervisory Board): Herbert K. Haas (Vorsitzender/Chairman); Vorstand (Executive Board): Ulrich Wallin (Vorsitzender/Chairman), Sven Althoff*, Claude Chèvre*, Jürgen Gräber*, Dr. Klaus Miller, Dr. Michael Pickel, Roland Vogel (*nur Mitglied des Vorstands der Hannover Rück SE/member of the Hannover Rück SE Executive Board only)
|