#1141 Contents not showing for some table

3.5.2
open
nobody
5
2014-05-16
2014-04-09
-c^s- Tan
No

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)

Discussion

  • -c^s- Tan

    -c^s- Tan - 2014-04-09

    Same problem using jDTS driver v1.3.1

     
  • sfst

    sfst - 2014-05-16

    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

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks