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: [email protected]
Reporter: [email protected]
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.
