Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Form-subform relation fails with direct SQL | ||||||
---|---|---|---|---|---|---|---|
Product: | Base | Reporter: | villeroy <villeroy> | ||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||
Status: | UNCONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 1.0.0 | ||||||
Target Milestone: | --- | ||||||
Hardware: | Unknown | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
villeroy
2008-11-29 08:27:36 UTC
Maybe you can attach a test case? Open the form of the attached database. Jump from item to item and watch the subform showing the category of the selected item. Close the form. Open any of the queries in SQL view and turn on direct SQL mode (Edit menu). Store the query and open the form again. The categories are not bound to the items anymore. Created attachment 58393 [details]
Form and subform bound to queries.
A workaround is to implement the Direct-SQL query as an view and use the view in the sub-form. This is however limited to read-only form-subform relations. Thanks for the work-around. Direct SQL-queries are read-only too. So this limitation does not make any difference. But why is almost every row set read-only in this database tool? Just want to confirm that I have also been burnt by this bug. Any use of Direct Mode SQL queryies in a linked form breaks the linkage. However a form based solely on this query is ok. A thread which details my own experience with discovering this bug here (http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=23229&p=106316#p106316). |