[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from bob...@openoffice.org Tue Oct 6 14:35:20 + 2009 --- 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). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from ville...@openoffice.org Sun Mar 15 23:02:19 + 2009 --- 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? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from erem...@openoffice.org Sun Mar 15 22:50:13 + 2009 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 19:24:01 + 2008 --- Created an attachment (id=58393) Form and subform bound to queries. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 19:21:32 + 2008 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 17:40:41 + 2008 --- Maybe you can attach a test case? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 Issue #|96703 Summary|Form-subform relation fails with direct SQL Component|Database access Version|1.0.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 08:27:36 + 2008 --- Load any form with a subform and change the source type of either one to some unparsed SQL query. For instance, change (sub-) form's source from "TableX" to direct SQL SELECT * FROM "TableX". The subform won't follow the main form anymore. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
