[dba-issues] [Issue 110111] No access to subform data in form (MS-Access)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110111 --- Additional comments from saro...@openoffice.org Wed Mar 17 19:23:30 + 2010 --- Sorry, but I performed a test in a MS-SQL database. The behavior was the same. Maybe this issue is fixed in in cws dba321a but this should be checked in my opinion. - 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 110111] No access to subform data in form (MS-Access)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110111 --- Additional comments from saro...@openoffice.org Mon Mar 15 08:05:48 + 2010 --- @ Aj: What does it mean for me? Today I'll try to - convert the database in Access 2007 format, so maybe I can work with this file ... My problem is that from 3.1.1 to 3.2.0 Oo has a diagram bugfix which I desperately need. So a return to Verion 3.1.1 is not really helpful... - 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 110111] No access to subform data in form (MS-Access)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110111 --- Additional comments from saro...@openoffice.org Sun Mar 14 11:26:06 + 2010 --- Created an attachment (id=68326) Access database - 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 110111] No access to subform data in form (MS-Access)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110111 Issue #|110111 Summary|No access to subform data in form (MS-Access) Component|Database access Version|OOo 3.2 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|sarotti --- Additional comments from saro...@openoffice.org Sun Mar 14 11:24:11 + 2010 --- - Using a MS-Access 2000 database file (mdb) - Creating a form with a subform (manually or by assistent) Result: In the subform no data is shown. It seems to be a problem with the linked fields / relations between main- and subform and the OO form query in the background. - 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 110111] No access to subform data in form (MS-Access)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110111 --- Additional comments from saro...@openoffice.org Sun Mar 14 11:27:03 + 2010 --- Created an attachment (id=68327) The odb file with the form - 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 103611] Form label fields not sho wn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103611 --- Additional comments from saro...@openoffice.org Wed Oct 7 18:55:59 + 2009 --- sarotti=fs: I checked other form documents - but to be honest - these are without a background pictures. They are perfect. But I´m wondering about another thing: The behavior depends on the number of labels. If only a few labels are in the form, you will not find this effect – or only a few labels are not shown. The critical thing - personally for me - is the colleagues in my company are working active with this database and forms. I had a hard job to implement OO in my company (there was a hard fight with the MS fraction...) and now these people discuss about the decision using with OO as an alternative to MS office programs. To be honest - for me it´s first of all a cosmetic thing. But it´s a question for me personally as you can imagine If you can give me an alternative - e.g. a special reload for the form view, it will help me in the first step. The OO 2.0 version we used before did not show this problem (The database form were developed on basis of this version. - 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 103611] Form label fields not sho wn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103611 Issue #|103611 Summary|Form label fields not shown Component|Database access Version|OOo 3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|sarotti --- Additional comments from saro...@openoffice.org Fri Jul 17 14:37:37 + 2009 --- I created several Form documents (odt), with a database connection. Opening a form does not show any label field. When scaling the document new (e.g. with scroll mouse) the labels will be shown correct. - 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 103611] Form label fields not sho wn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103611 --- Additional comments from saro...@openoffice.org Fri Jul 17 14:38:14 + 2009 --- Created an attachment (id=63604) Example for problem - 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 103611] Form label fields not sho wn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103611 --- Additional comments from saro...@openoffice.org Fri Jul 17 14:38:53 + 2009 --- Created an attachment (id=63605) label problem view - 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 103611] Form label fields not sho wn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103611 --- Additional comments from saro...@openoffice.org Fri Jul 17 14:47:06 + 2009 --- Sorry, the original background is blue (jpg-file)... the fonts colour ist white so you first have to change the background colour to verify this issue. - 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
[graphics-issues] [Issue 102811] Deleting a column does no t actualize the chart
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102811 Issue #|102811 Summary|Deleting a column does not actualize the chart Component|Chart Version|OOo 3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|kla Reported by|sarotti --- Additional comments from saro...@openoffice.org Mon Jun 15 18:50:48 + 2009 --- Deleting a column does not actualize the chart Creating a chart based on several columns, deleting one of these columns does not actualize the chart correctly. Example: Create a bar or line-chart based on the data in A1:E5. Delete e.g. column B and you get an interesting result. The new colunm B is twice in the chart and the number of bars / lines does not change. Best regards sarotti - 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...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 102811] Deleting a column does no t actualize the chart
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102811 --- Additional comments from saro...@openoffice.org Mon Jun 15 18:53:23 + 2009 --- Created an attachment (id=63009) Example calc chart - 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...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 102369] hiding columns has no eff ect to chart
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102369 --- Additional comments from saro...@openoffice.org Sat May 30 17:02:44 + 2009 --- Created an attachment (id=62656) example to show you the problem - 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...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 102369] hiding columns has no eff ect to chart
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102369 --- Additional comments from saro...@openoffice.org Sat May 30 17:03:45 + 2009 --- O.K. ..I try to explain it once again (and I sent before a pdf file to show you what I mean) - the data in a spreadsheet of calc: columns A to F - create a line chart with this data column A:F - In the chart you´ll see 6 lines (A to F) based on the columns - hide column E and F - normally the result was two lines are also hidden in the chart - in version 3.1 (I used before2.0) there is no effect on the chart - the lines of the hidden column E and F are still shown in the chart ...hope you can reproduce now my problem - 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...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from saro...@openoffice.org Fri May 29 16:58:26 + 2009 --- @atjensen: To be honest - I am not sure about version 2.4.1, because I tested it originally with 2.0.0 (in my company) and it was absolut O.K. The macros with the SQL query were running without any problem... ! - 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
[graphics-issues] [Issue 102369] hiding columns has no eff ect to chart
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102369 Issue #|102369 Summary|hiding columns has no effect to chart Component|Chart Version|OOo 3.1 Platform|DEC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|configuration Assigned to|kla Reported by|sarotti --- Additional comments from saro...@openoffice.org Fri May 29 17:13:18 + 2009 --- Hi, creating a chart, based on several columns and hide later some of the columns, does not hide the lines/bars in the chart. In OO 2.0 to 3.0 the function exists. I need this function because I generate per macro from a database charts automatically and the user has the option to hide some lines/bars per API code from the chart to get a better overview. Also the manual test has the same effect. P.S. ...Is there a possibility to predefine globally the line width for the whole chart before creating it? - 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...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from saro...@openoffice.org Thu May 28 15:22:52 + 2009 --- ajtensen- using the Base MS Access connection under Windows to work with the .mdb file, not an external ODBC connection for instance? Correct, it´s the original MS Access OO driver... Sorry, but I have no example in a HSQL database, but I tried it and it was the same...not in the macro code - I have not tested this - but in the database query the frozen system was the same... - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from saro...@openoffice.org Tue May 26 19:45:45 + 2009 --- Created an attachment (id=62548) My sample Access 97 database - 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 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 --- Additional comments from saro...@openoffice.org Tue May 26 19:54:07 + 2009 --- fs-Thank you for your fast feedback...attached you can find my Access 97 database with the problems in the query. atjensen-yes, it works in the macro code (oStatement.EscapeProcessing = False) but the same happens when creating a query in the database itself in the design mode. It´s a little bit strange for OO only hanging or freezing without a message...so my interpretation is, that there is a code failure in OO ... - 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
[api-issues] [Issue 102234] Database query does not w ork correct in API code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102234 Issue #|102234 Summary|Database query does not work correct in API code Component|api Version|OOo 3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|code Assigned to|jsc Reported by|sarotti --- Additional comments from saro...@openoffice.org Mon May 25 18:10:56 + 2009 --- Hi, I created several database query's in my macro code which are not running with OO 3.1. These querys all have relations between more than two tables and are defined like this: „... sSQL=SELECT `DOKUMENT`.`Kapitel`, `DOKUMENT`.`Typ`, `DOKUMENT`.`Titel`, `DOKUMENT`.`Link`, `DOKUMENT`.`Blatt`, `DOKUMENT`.`Nr`, `DOKUMENT`.`erlDatum`, `DOKUMENT`.`Revision`, `DOKUMENT`.`DotName` FROM `VertNeu` `VertNeu`, `DOKUMENT` `DOKUMENT`, `Handbuch` `Handbuch` WHERE ( `VertNeu`.`ID_Dokument` = `DOKUMENT`.`ID`) AND (`VertNeu`.`ID_Handbuch` = `Handbuch`.`ID_Handbuch` ) AND ( ( `Handbuch`.`Nummer` = '05' ) ) AND ( ( `Handbuch`.`Abteilung` = 'QW-L' ) ) ORDER BY `DOKUMENT`.`Kapitel`, `DOKUMENT`.`Nr` ASC oErgSet=oStatement.executeQuery(sSQL) ….“ This code is running perfect with OO 2.4 - with 3.1 there is a frozen / hanging system. Also the change to an LEFT OUTER JOIN query has the same effect, but is only working correctly with two related tables. Using the SQL code in the database directly the query only is running when the SQL code is used as a direct command (like before in the macro code in OO 2.4.1). I found no way to define my macro code to work as a direct query command (e.g. with the API command naturalSQL) Because I need this query's to operate with my several databases in my company, I need top urgent a solution for this issue. Thank you for your assistance. P.S. It´s an MS-Access 97 Database. But the test with an HSQL database shows the same behavior - 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...@api.openoffice.org For additional commands, e-mail: issues-h...@api.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 87741] Macros not accessible in f orm opened from external document
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87741 --- Additional comments from [EMAIL PROTECTED] Mon Apr 21 07:18:32 + 2008 --- Hi all, this behaviour is indeed new and not very funny. The former versions (before 2.4.0) did not show this problem. In the german OO forum this problem is described from several people who downgraded to an old OO Version. I found out that the MacroEcecutionMode tip ALWAYS_EXECUTE_NO_WARN work but all Macros opening a document must be modified Last but not least it is not only in database forms but with ALL documents which are opened indirectly by using a macro. sarotti - 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]
[api-issues] [Issue 81509] API in diagram - title, su btitles and axis titles
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81509 User sarotti changed the following: What|Old value |New value Assigned to|sarotti |jsc --- Additional comments from [EMAIL PROTECTED] Fri Sep 21 09:14:11 + 2007 --- Thank you for this information and your help, but I was really surprised to see, that my old code did this mistake without any failure message. So I thought it´s a mistake in the OO 2.3 version ... If there would be a message nobody would think about sending an issue for this sarotti - 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]
[api-issues] [Issue 81509] API in diagram - title, su btitles and axis titles
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81509 Issue #|81509 Summary|API in diagram - title, subtitles and axis titles Component|api Version|OOo 2.3 RC2 Platform|Opteron/x86_64 URL| OS/Version|Windows 98 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|jsc Reported by|sarotti --- Additional comments from [EMAIL PROTECTED] Tue Sep 11 18:24:47 + 2007 --- Hi all, I created a code which automatically creates a chart diagramm in a spreadsheet. In version 2.0 and until 2.2.1 everything worked perfect. But in 2.3.0 RC2 my code the titles, subtitle and axis title cant be set in the diagram. Manually it works perfect. My code for this is ... Chart.Title.String=My title oDia=Chart.Diagram oDia.YAxisTitle.String=My Y-Axis text oDia.HasYAxisTitle=True oDia.XAxisTitle.String=My X-Axis text oDia.HasXAxisTitle=True Thank you for yout assistance. best regards sarotti - 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]
[api-issues] [Issue 72146] date conversion in macro S QL code
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72146 User sarotti changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 13:15:22 -0800 2006 --- Sorry, I checked everything (also I changed to 2.1 RC2) and now the error is not reproducible. I made some tests, and maybe it is a (or my) mistake in declaration the variables. I made the experience that SQL Macro Code with a date (DIM xxx as Date) is criticel to use when you create a query. But when you use a date-string it´s easier. I wrote a small function to convert a date in the standard SQL string (using the command CDateToIso) and now it´s working fine. function function_Date_Convert(date_basis as string) '// this function converts a date in a usable SQL date Dateconv=CDateToIso(date_basis) sYear=left(Dateconv, 4) sDay=right(Dateconv, 2) sMonth=mid(Dateconv,5,2) function_Date_Convert=sYear + - + sMonth + - + sDay end function Using this the date format is independent on the language code and it´s easier to handle. Now it´s possible to use it like this: sDate=01.01.2006 sDate=function_Date_Convert(sDate) sSQL=SELECT * FROM `table1` WHERE `Datefield` = # + sDate + ' resultSet=executeQuery(sSQL) . So, think it´s solved now Thank you for your cooperation sarotti - 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]
[api-issues] [Issue 72146] date conversion in macro S QL code
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=72146
Issue #|72146
Summary|date conversion in macro SQL code
Component|api
Version|OOo 2.1
Platform|All
URL|
OS/Version|Windows 98
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|code
Assigned to|jsc
Reported by|sarotti
--- Additional comments from [EMAIL PROTECTED] Thu Nov 30 08:54:24 -0800
2006 ---
Hi,
problem with RC1 of OO 2.1:
there is a problem with a date code in macro programming
example for the SQL-Code:
Select * FROM `table_x` WHERE `date1` ={D '2006-11-29'} AND `date2` = {D '2006-
11-29'} AND
This SQL command is working in my MySQL database (as well in the native SQL
Code and also as an OO query). If I use an executeQuery command in a macro
code, the date code is converted. Now there are slashes / (... `date1` =#2006/
11/29# ) in the command, as a result there occures a runtime error in basic
(syntax error in query).
Also changing the language settings doesn´t change this
Thank you for your help
best regards
sarotti
-
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]
[api-issues] [Issue 71048] macro events on form compo nents can´t be removed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71048 Issue #|71048 Summary|macro events on form components can´t be removed Component|api Version|OOo 2.0.4 Platform|Opteron/x86_64 URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|jsc Reported by|sarotti --- Additional comments from [EMAIL PROTECTED] Tue Oct 31 11:46:39 -0800 2006 --- Once there is an event on a form component defined (e.g. a button or text filed) the macro works perfectly, but you are not able to remove the event. This remove function doesn´t work. Using the remove button in the dialog the event script is not shown any more, but when you leave this dialog it´s not removed in the properties dialog of the form component. hope you´ll find a solution... thank you sarotti - 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 62127] New - HSQL - creating a vi ew
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62127 Issue #:|62127 Summary:|HSQL - creating a view Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|Windows 98 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|sarotti --- Additional comments from [EMAIL PROTECTED] Thu Feb 16 02:13:25 -0800 2006 --- Hi, deleting a table view is possible, but not creating a view with the same name without closing OpenOffice (or reboot the system) best regards sarotti - 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]
[api-issues] [Issue 61896] New - Issue:61869, HSQL ac cess and update via Makro
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61896 Issue #:|61896 Summary:|Issue:61869, HSQL access and update via Makro Component:|api Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Windows 98 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|sw Reported by:|sarotti --- Additional comments from [EMAIL PROTECTED] Fri Feb 10 04:51:08 -0800 2006 --- This issue based on Issue 61869 - I don´t know the correct contact person/ programmer): Using a makro to access and update HSQL databases produces an error. Here is the macro code (P.S. please see below the comments of marc): Sub ResetTMP Dim DatabaseContext as Object Dim s as string Dim oDatenquelle as Object Dim oHandler as Object Dim oDatVerb as Object Dim oStatement as Object Dim oErgSet as Object Dim sSQL as String DatabaseContext = createUnoService(com.sun.star.sdb.DatabaseContext) oDatenquelle = DatabaseContext.getByName(Adress_db) If not oDatenquelle.IsPasswordRequired Then oDatVerb = oDatenquelle.getConnection(,) else oHandler = oDatenquelle.createUnoService(com.sun.star.sdb.InteractionHandler) oDatVerb = oDatenquelle.ConnectWithCompletion(oHandler) end if oStatement = oDatVerb.createStatement() oStatement.ResultSetConcurrency = com.sun.star.sdbc.ResultSetConcurrency.UPDATABLE oStatement.ResultSetType = com.sun.star.sdbc.ResultSetType.SCROLL_SENSITIVE sSQL =SELECT TMP1, TMP2, TMP3 FROM TMP oErgSet = oStatement.executeQuery(sSQL) oErgSet.absolute(1) REM die folgenden 3 Zeilen ändern den Inhalt der 1.-3. Spalte des Ergebnisses der Abfrage sSQL oErgSet.updateString(1, text1) 'here you get the error oErgSet.updateString(2, text2) oErgSet.updateString(3, text3) oErgSet.updateRow() End sub The error: Basic runtime error ...exception Type: com.sun.star.sdbc.SQLException Message: Function Sequence error. Using other databases (like MS-Access)the update function with the macro will run. best regards - Jörg Leistikow - --- Additional comments from msc Fri Feb 10 00:51:41 -0800 2006 --- Hi, I can reproduce this, reassign it to the right developer and set target. Bye Marc - 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 61871] New - (HSQL) table view do esn´t run stable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61871 Issue #:|61871 Summary:|(HSQL) table view doesn´t run stable Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|Windows 98 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|sarotti --- Additional comments from [EMAIL PROTECTED] Thu Feb 9 12:56:57 -0800 2006 --- producing a view from a query does not run stable. 1. once created a view you can´t rename it 2. deleting a view is possible, but not creating a view with the same name without closing OpenOffice (or reboot your system) 3. A view can´t be edited (only the basis query, later you have the problems see point 1. and 2.) 4. When there is a mistake in a view (can´t specify...) and your database crashes, then you have no chance to get access to your tables. You get an error and you can´t do anything then recreate the whole databasevery bad! best regards - Jörg Leistikow - - 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 61869] New - HSQL access/field up date via macro doesn´t work
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61869 Issue #:|61869 Summary:|HSQL access/field update via macro doesn´t work Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Windows 98 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|sarotti --- Additional comments from [EMAIL PROTECTED] Thu Feb 9 12:45:22 -0800 2006 --- Using a makro to access and update HSQL databases produces an error. Here is the macro code: Sub ResetTMP Dim DatabaseContext as Object Dim s as string Dim oDatenquelle as Object Dim oHandler as Object Dim oDatVerb as Object Dim oStatement as Object Dim oErgSet as Object Dim sSQL as String DatabaseContext = createUnoService(com.sun.star.sdb.DatabaseContext) oDatenquelle = DatabaseContext.getByName(Adress_db) If not oDatenquelle.IsPasswordRequired Then oDatVerb = oDatenquelle.getConnection(,) else oHandler = oDatenquelle.createUnoService(com.sun.star.sdb.InteractionHandler) oDatVerb = oDatenquelle.ConnectWithCompletion(oHandler) end if oStatement = oDatVerb.createStatement() oStatement.ResultSetConcurrency = com.sun.star.sdbc.ResultSetConcurrency.UPDATABLE oStatement.ResultSetType = com.sun.star.sdbc.ResultSetType.SCROLL_SENSITIVE sSQL =SELECT TMP1, TMP2, TMP3 FROM TMP oErgSet = oStatement.executeQuery(sSQL) oErgSet.absolute(1) REM die folgenden 3 Zeilen ändern den Inhalt der 1.-3. Spalte des Ergebnisses der Abfrage sSQL oErgSet.updateString(1, text1) 'here you get the error oErgSet.updateString(2, text2) oErgSet.updateString(3, text3) oErgSet.updateRow() End sub The error: Basic runtime error ...exception Type: com.sun.star.sdbc.SQLException Message: Function Sequence error. Using other databases (like access)the update function with the macro will run. best regards - Jörg Leistikow - - 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 61870] New - Formatting of curren cy doesn´t work correct
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61870 Issue #:|61870 Summary:|Formatting of currency doesn´t work correct Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|Windows 98 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|sarotti --- Additional comments from [EMAIL PROTECTED] Thu Feb 9 12:48:40 -0800 2006 --- using a e.g. a currency formatting (for example negative values red) doesn´t work correct. The whole table is red, not only the negative values. best regards - Jörg Leistikow- - 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]
[api-issues] [Issue 59904] New - CreateUnoService doe sn´t create new frame
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59904 Issue #:|59904 Summary:|CreateUnoService doesn´t create new frame Component:|api Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|Windows 98 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|sw Reported by:|sarotti --- Additional comments from [EMAIL PROTECTED] Fri Dec 30 13:13:21 -0800 2005 --- the following macro doesn´t work correct in the 2.0.1 version but only in 2.0.0. The file form1 is loaded, but using the same code to open another file creates a new frame. It´s not opened in the same frame. Sub LoadForm1 Dim oDoc1 As Object Dim sURL1 As String Rem Load a documents into the frame myframe! oDesk = createUnoService(com.sun.star.frame.Desktop) Dim NoArgs() Rem Frame myframe will be created if it does not exist because it includes CREATE sUrl_1 = file:///C:/Form1.odt oDoc1 = oDesk.LoadComponentFromUrl(sUrl_1, myframe, 63, Noargs()) End Sub - 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]
[sw-issues] [Issue 58913] New - HTML template styles doesn´t work
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58913 Issue #:|58913 Summary:|HTML template styles doesn´t work Component:|Word processor Version:|OOo 2.0 Platform:|Other URL:| OS/Version:|Windows 98 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|formatting Assigned to:|mru Reported by:|sarotti --- Additional comments from [EMAIL PROTECTED] Mon Dec 5 11:38:13 -0800 2005 --- I changed the original openoffice HTML template for my homepage. Using the styles in an n e w document is O.K. But when the file is saved and opened again, the formats/styles of the original openoffice template are active and not my modified. In the stylist they are shown corectly, but the document is not actualized when opened. Also the formatting of tables in an template is not possible. best regards sarotti - 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]
