|
From: <Ste...@ha...> - 2016-03-04 07:03:34
|
Hello, I am using 3.7 and the error was verified externally by the database support too. Kind regards Stefan Marquardt, Information Technology, IT Domain Direct | Hannover Re, Karl-Wiechert-Allee 50, 30625 Hannover, Germany | Phone +49 511 5604 2799, Fax +49 511 5604 4799, ste...@ha... | www.hannover-re.com -----Original Message----- From: Gerd Wagner [mailto:ger...@t-...] Sent: Donnerstag, 3. März 2016 21:34 To: Marquardt Stefan; squ...@li... Subject: Re: [Squirrel-sql-develop] Fields and tables with "-" included Hi Stefan, which version of SQuirreL are you using? A similar bug was fixed shortly before the 3.7 release, see https://sourceforge.net/p/squirrel-sql/bugs/1210/ The fix should be included in 3.7 as well as in later snapshots. Gerd Am 25.02.2016 um 16:12 schrieb Ste...@ha...: > 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) > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
