Edit Question - KnowledgeHub

Title Body

I tried add an column alias in SELECT statement using SQuirrel SQL 3.4 + Firebird 1.5 + Driver JDBC Jaybird 2.2.[0|1] (JVM 1.7.0_03), but doesn't work. The column aliased appears with the original name of column. In another tool (DBExpert) the same statement works fine. Statement : SELECT column1 AS alias1, column2 FROM table; Resultant columns name in SquirrelSQL : column1 - column2 Resultant columns name in DBExpert : alias1 - column2 Tried add ' and " around alias name, but also not work. Someone have an idea? Edit: I updated the JDBC Jaybird driver to 2.2.1 version (released Sept/30) and the problem remains. Edit 2: Problem fixed! The problenm is caused by default preferences of Squirrel SQL. To fix it, go to "File" -> "Global Preferences", in tab "Data Type Controls" find "General (applies to all types)" and mark the combo-box "Use column labels instead of column names in result headers". See the screenshot: http://i1-win.softpedia-static.com/screenshots/SQuirrel-SQL-Client_4.png?1345342622 Enjoy.

Tags (comma-separated) Cancel