|
From: Michael F. <mic...@be...> - 2007-03-08 08:53:13
|
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=20 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=E2=80=99t matter if they were commands. I hope on any answer. Michael Michael Feill wrote: >=20 >=20 > I am using DB2 on z/OS with field names (also keys) containing dashes. > I.E.: =E2=80=9CABC-DEF-GHI=E2=80=9D >=20 > 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" =3D 'XYZ' >=20 > On updates to a row the double quotes are missing and I got a SQL error. >=20 > Has any body a tip how to solve this without changing the field names? >=20 > Thanks >=20 >=20 >=20 --=20 View this message in context: http://www.nabble.com/Missing-double-quotes-f= or-field-names-tf2964954.html#a9370774 Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
