Re: Missing double quotes for field names

I am still waiting on an answer.

In the meanwhile I made a Patch to Squirrel 2.4.
I changed all DataType* Classes in the framework. When they get the Label
from the Column I added double quotes.
In the Client part I changed WhereClausePanel.addTextToClause() and 
DataSetUpdateableTableModelImpl .updateTableComponent()

Now it works fine.

For my opinion Squrril should use getIdentifierQuoteString of the Database
to surround all field names in SQLs. This handling is also wrong in the
plugins. E.g. DBCopy has extra flags to check if a field is a command in a
database. If the fields were quoted it wouldn’t matter if they were
commands.

I hope on any answer.

Michael


Michael Feill wrote:
> 
> 
> I am using DB2 on z/OS with field names (also keys) containing dashes.
> I.E.: “ABC-DEF-GHI”
> 
> If I use a filter I am able to add the required double quotes for field
> names manually in the edit window.
> I.E.: "ABC-DEF-GHI" = 'XYZ'
> 
> On updates to a row the double quotes are missing and I got a SQL error.
> 
> Has any body a tip how to solve this without changing the field names?
> 
> Thanks
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Missing-double-quotes-for-field-names-tf2964954.html#a9370774
Sent from the squirrel-sql-users mailing list archive at Nabble.com.


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users