[dba-issues] [Issue 114280] PostreSQL subforms broken with ODBC, JDBC
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114280 --- Additional comments from peterdi...@openoffice.org Sat Sep 4 01:37:26 + 2010 --- Same flaw affects H2 database with JDBC - cannot display, edit or add subform data with OOo 3.2.1 - 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
[dba-issues] [Issue 114299] Error with some valid que ries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114299 Issue #|114299 Summary|Error with some valid queries Component|Database access Version|OOO320m12 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|prune --- Additional comments from pr...@openoffice.org Fri Sep 3 20:34:49 + 2010 --- The following query works on MySQL Workbench but gives an error in OpenOffice.org Base 3.2 (using the same database, of course): SELECT address, A.podID, adID, SUM(duration * IFNULL(startDate<='2010-02-24' AND endDate>='2010-02-24', 0)) FROM `cfm`.`adpod_schedule` AS A, `cfm`.`adpod` AS B WHERE startDate <= '2010-03-31' AND endDate >= '2010-01-06' AND A.podID=B.podID GROUP BY adID; In order to get it to work in Base, I had to replace SUM(duration * IFNULL(startDate<='2010-02-24' AND endDate>='2010-02-24', 0)) with SUM(duration * IFNULL(startDate <= '2010-02-24', 0) * IFNULL(endDate >= 2010-02-24', 0)) Quite annoying, as you can see. Interestingly, the IFNULL is colored green instead of blue as it should be, suggesting this is a parsing issue and there are problems with Base handling expressions within SUM(). - 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
[dba-issues] [Issue 111349] Text field value is not d isplayed when field is in table control
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111349 User fs changed the following: What|Old value |New value OS/Version|Linux |All Platform|PC|All Target milestone|OOo 3.4 |OOo Later --- Additional comments from f...@openoffice.org Fri Sep 3 15:29:42 + 2010 --- oj's previous comment doesn't belong into this issue, /me thinks, this problem here has nothing to do with the drawing layer ... Targeting to Later - 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
[dba-issues] [Issue 114280] PostreSQL subforms broken with ODBC, JDBC
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114280 --- Additional comments from peterdi...@openoffice.org Fri Sep 3 15:14:55 + 2010 --- As per a user comment on a forum, I verified that PostreSQL JDBC subforms DO work properly in OOo 3.1.1 - 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
[dba-issues] [Issue 114287] missing data in Mac Base from Calc table comp. to Win
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114287 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' --- Additional comments from atjen...@openoffice.org Fri Sep 3 14:50:33 + 2010 --- Confirmed the issue using Go-oo 3.2.1 / Lucid 10.04 (amd4) - the result set in the dataview is identical to what you show in the MAC png. Using OOO330m_5 / Lucid 10.04 (AMD64) it works properly and returns all zip codes. - 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
[dba-issues] [Issue 114280] PostreSQL subforms broken with ODBC, JDBC
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114280 --- Additional comments from peterdi...@openoffice.org Fri Sep 3 11:57:10 + 2010 --- This was with both the 9.0 rc1 and 8.4.4 stable versions. Thanks for looking into this so promptly! - 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
[dba-issues] [Issue 114187] Cannot see/remove query s orts from "order by" statement in query view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 --- Additional comments from f...@openoffice.org Fri Sep 3 11:37:58 + 2010 --- ah, I used the wrong version! In fact, in OOo 3.2.1, for both "HeadsOrTails-NoSort-DirectSQL" and "Query_DirectSQL", the filter/sort buttons are enabled when opening the queries by double-clicking them. In OOo 3.3 Beta 1, this is fixed - so seems this issue is gone meanwhile. - 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
[dba-issues] [Issue 96825] in base query format is no t memorized
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96825 --- Additional comments from f...@openoffice.org Fri Sep 3 11:25:35 + 2010 --- unlikely, IMO - 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
[dba-issues] [Issue 96825] in base query format is no t memorized
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96825 --- Additional comments from maurice_sta...@openoffice.org Fri Sep 3 11:15:55 + 2010 --- Just an idea before doing a new test: could the problem come from a corrupted profile? - 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
[dba-issues] [課題 114273] Query wizard: cannot se t more than one conditions at "3.Serach condit ions"
http://www.openoffice.org/issues/show_bug.cgi?id=114273 ユーザ enoki は、次を変更しました: 内容|古い値 |新しい値 CC|'matayoshi' |'enoki,matayoshi' - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 96825] in base query format is no t memorized
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96825 --- Additional comments from f...@openoffice.org Fri Sep 3 09:32:36 + 2010 --- definitely "yes" - 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
[dba-issues] [Issue 114287] missing data in Mac Base from Calc table comp. to Win
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114287 --- Additional comments from r_rethm...@openoffice.org Fri Sep 3 09:16:45 + 2010 --- Created an attachment (id=71544) sample docs, screen shots - 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
[dba-issues] [Issue 114287] missing data in Mac Base from Calc table comp. to Win
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114287 Issue #|114287 Summary|missing data in Mac Base from Calc table comp. to Win Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.6 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|r_rethmann --- Additional comments from r_rethm...@openoffice.org Fri Sep 3 09:15:52 + 2010 --- Strange issue. I've created an address list in calc. Then I've created a Base doc based on the calc table. When I query the table from within the base doc, almost all zip codes are missing. Viewing the same doc with Windows OOO-Base, all zip codes are shown. So it must be an OOO-Mac issue. Please find screen shots and example Calc/Base docs enclosed. - 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
[dba-issues] [Issue 113991] "Graphics" property of fo rm controls does not display existing properti es anymore
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113991 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Fri Sep 3 08:43:46 + 2010 --- verified in CWS dba33h find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33h - 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
[dba-issues] [Issue 114122] image controls cannot emb ed images in the document (anymore)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114122 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Fri Sep 3 08:42:50 + 2010 --- verified in CWS dba33h find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33h - 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
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Fri Sep 3 08:07:56 + 2010 --- verified in CWS dba33h find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33h - 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
[dba-issues] [Issue 96825] in base query format is no t memorized
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96825 --- Additional comments from maurice_sta...@openoffice.org Fri Sep 3 08:06:38 + 2010 --- If I refer my daily experience nothing has been fixed in version 3.2.1. I still loose regularly ALL formats in my queries, not only the alignments but also the numeric formats. I can't understand that you are not able to reproduce it. I use the French version but I believe that it's not related to the loss of query format. I'll build an other small application to test the bug on a new file. Are you interested to get it... if the problem persists? - 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
[dba-issues] [Issue 112659] [Windows 7] image control s bound to text columns store a wrong image UR L
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112659 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Fri Sep 3 07:52:50 + 2010 --- verified in CWS dba33h find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33h - 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
[dba-issues] [Issue 114022] Last images remained in d atabase forms
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114022 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Fri Sep 3 07:26:23 + 2010 --- verified in CWS dba33h find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33h - 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