You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/09/30 06:03:40 UTC
[Issue 126563] New: Broken links after renaming tables/queries used
in queries
https://bz.apache.org/ooo/show_bug.cgi?id=126563
Issue ID: 126563
Issue Type: DEFECT
Summary: Broken links after renaming tables/queries used in
queries
Product: Base
Version: 4.1.1
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: minor
Priority: P5
Component: code
Assignee: issues@openoffice.apache.org
Reporter: kbarber@lakeheadu.ca
The title says it all. If you rename tables/queries that are used in queries,
then those queries will be invalid since they still contain the old names. You
can't even use Design View to fix this; you have to edit the SQL manually to
reflect the new names.
I think that OpenOffice Base can take a lesson from OpenOffice Calc or
Microsoft Excel. In these programs, you can rename sheets and defined names and
the rename will propagate to wherever the sheet/name is used, at least within
the same file. Similarly, I can understand a link break in the case where an
external program refers to an OpenOffice Base table, but when it's completely
internal, there is no reason to not update all links to a table after it is
renamed.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126563] Broken links after renaming tables/queries used in
queries
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126563
--- Comment #2 from kbarber@lakeheadu.ca ---
(In reply to mroe from comment #1)
> A database (server) is different and complete independent from a query
> (client). A database editor should know what he is doing.
I understand that full database access should be restricted to the most trusted
and experienced of people, but if the feature that I mentioned were
implemented, I doubt that there would be much complaint. It's not needed; it's
just nice.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126563] Broken links after renaming tables/queries used in
queries
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126563
--- Comment #3 from mroe <mr...@gmx.net> ---
It can't be implemented. The database server doesn't know the clients. There
can be many clients.
There is only a special case for an embedded HSQL database inside a database
document (.odb) where server (HSQL) and client (AOO Base) act as an unit. But
also in this case the server doesn't know anything about the stored queries.
A query is simply a SQL string.
SELECT t1.field1 FROM table1 t1
There are no objects which interacts with server objects. Simply "words".
Drop or rename "table1" from the database and the query will be invalid.
Create a new table "table1" with a column "field1" and you will get a valid
result again.
The AOO Base query designer makes it easy for you to create a query as it shows
you the available objects of the connected database at /this moment/. Leave the
design mode and you see the resulting SQL statement. This string is stored. No
more, no less.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126563] Broken links after renaming tables/queries used in
queries
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126563
kbarber@lakeheadu.ca changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kbarber@lakeheadu.ca
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126563] Broken links after renaming tables/queries used in
queries
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126563
kbarber@lakeheadu.ca changed:
What |Removed |Added
----------------------------------------------------------------------------
Issue Type|DEFECT |ENHANCEMENT
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126563] Broken links after renaming tables/queries used in
queries
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126563
mroe <mr...@gmx.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOT_AN_ISSUE
Status|UNCONFIRMED |RESOLVED
--- Comment #1 from mroe <mr...@gmx.net> ---
A database (server) is different and complete independent from a query
(client). A database editor should know what he is doing.
--
You are receiving this mail because:
You are the assignee for the issue.