|
From: Federico B. <fe...@in...> - 2018-05-21 16:41:29
|
Hi all
I see that Squirrel SQL does not allow to edit the content of a JOIN
result.
Only simple queries.
There's any workaround?
Perhaps this limitation could be explicitly mentioned in the
documentation.
This is what I read in the help pages. (there's no online
documentation, right?)
Editing Data in the SQL Results Tables
The data displayed within the SQL Results may be edited in the same
manner as the data within the Contents Tab. You should read that
section to understand the capabilities and limitations of data editing,
including the use of the Popup window to import and export data. In
addition, there are two things that you need to know about editing in
the SQL Results:
To enable editing in the SQL Results tables, you must set the "SQL
Results" entry in the Session Properties to "Editable Table".
Editing is only allowed when the SQL that was executed consists of:
"SELECT <column list> FROM <single_table_name>"
or
"SELECT <column list> FROM <single_table_name> WHERE ..."
In addition, the name of the table must be unique within the entire DB.
This means that if you have multiple catalogs or schemas which have
that same table name defined in them, Squirrel cannot determine which
to use and thus will not allow data to be updated in the DB. (Squirrel
is just a bit stupid on this point: it will let you edit the data, and
then tell you that it cannot update the DB when you exit the cell being
changed.)
The Contents Tab and Editing Data
SQuirreL allows you to easily view and change the data in a single
table. Data may be changed just by typing the new values when you are
viewing the table in the Contents tab under the Objects view. The data
may also be viewed and edited in a larger popup window, which has more
capabilities, by double-clicking on the cell. There are some small
differences between the in-cell editing and editing in the Popup, so be
sure to read the Using the Popup Window information.
|
