Contents not showing for some table
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
In MSSQL, if the table has a column named "Order" (any datatype), the Content tab will not work. Eg:
CREATE TABLE "dbo"."TestTable007" ( [Order] nvarchar(100) )
Confirmed with these:
com.microsoft.sqlserver.jdbc.SQLServerDriver v4.0.2206.100
MSSQL 2012 Express v11.00.3000
MSSQL 2008R2 Express v10.50.4000
No problem on MySQL. (probably issue with MSSQL driver but it works in Squirrel v3.5.0)
Same problem using jDTS driver v1.3.1
Can you please specify what does "the Content tab will not work" mean? No values shown, or some error message?
In Oracle I must quote the column name in this case, e.g. create table order_test("Order" number);
and then always use the exact upper/lower case for quoted columns, e.g. SELECT "Order" FROM order_test;
If I use SELECT "order" FROM order_test; I get an error that the identifier "order" is not known.
If I use SELECT Order FROM order_test; the error is about a missing expression.
Last edit: sfst 2014-05-16