Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
3.0M5
-
None
-
Linux, Sun JDK1.5, MS SQL Server 2000, jtds-1.0, Croatian locale
Description
Say a table "t0" has an attribute "my attrib 0".
You correct the obj-attribute to, for instance, "my_attrib_0", but the db-attribute is still "my attrib 0".
When you try to run a query on "t0", the generated query looks like:
SELECT ..., t0.my attrib 0, ... FROM dbo.t0 AS t0
This, obviously, can't possibly work.
The correct SQL would be:
SELECT ..., t0.[my attrib 0], ... FROM dbo.[t0] AS t0
Notice the square brackets arround the attributes and table names: that makes the string a valid attribute or table name valid.
A further improvement might be to add the database name:
SELECT ..., t0.[my attrib 0], ... FROM [dbname].dbo.[t0] AS t0
I mention it because I use the quantum plugin as a database access plugin and it complained about a table called "dbo.tablename" (as I believe it should) and all was well when I used mydbname.dbo.tablename.
