[dba-issues] [Issue 115420] Base: NULL date import br eaks type recognition & crashes OOo 3.3.0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115420 --- Additional comments from atjen...@openoffice.org Mon Nov 22 08:19:32 + 2010 --- Created an attachment (id=75084) Table8 has data directly after import from test ODS file - with bad display variable - 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 115420] Base: NULL date import br eaks type recognition & crashes OOo 3.3.0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115420 --- Additional comments from atjen...@openoffice.org Mon Nov 22 08:17:07 + 2010 --- @yutgor - following your steps I can reproduce the erroneous import. (but not with the OO.o RC5 so someone else will need to do that to be sure) It is actually not the data that is corrupt but there is an error, in the GUI default format property for the table, as you describe. To see that it is not the data that is corrupt. Download the ODB file i115420, attached here. The file has two tables, Table7 and Table8 - these are created from your example .ods file, with the Memo data type. Table7 appears to have correct data and Table8 incorrect. To Fix Table8, you must do ALL of this Open Table8 definition for edit. Select the Desc field Click on the button to the right of the "Format example" In this dialog you must clear the ERROR by 1 - change to any user defined value - i.e. '@@' 2 - change back to the correct defaut for text '@' Save the table definition. Correct data is there. So the error is right at that format variable... Finally - I used on Linux, so no comment on the crash part of this only the problem with the display after import. - 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 114403] Oo crashes using "form ba sed filters" and a "list box" control
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114403 --- Additional comments from atjen...@openoffice.org Wed Sep 8 21:32:54 + 2010 --- Created an attachment (id=71622) example bug doc - example 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
[dba-issues] [Issue 114403] Oo crashes using "form ba sed filters" and a "list box" control
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114403 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Wed Sep 8 21:31:08 + 2010 --- Confirmed using Ubuntu 10.04 / OOO330m_6 / go-oo 3.2.1 (proposed) - hsql embedded Open the attached file Open the form Select form based filter use the list box, second column on table grid, to sett a criteria 'aaa' Activate filter Immediate crash both builds Crash report from ooo330m_6 sent - but have not got the confirmation back yet..when I do will update with the number - 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 114304] Default not being set pro perly when creating a boolean field via SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114304 --- Additional comments from atjen...@openoffice.org Sun Sep 5 03:21:36 + 2010 --- Created an attachment (id=71564) changed boolean field - and form control is set to tri-state true - 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 114304] Default not being set pro perly when creating a boolean field via SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114304 --- Additional comments from atjen...@openoffice.org Sun Sep 5 03:18:34 + 2010 --- @villeroy - I can't do that here - using 3.2.1 (vanilla) on linux if I try to apply, using the SQL window, your example: ALTER TABLE BOOLS ADD COLUMN ABOOLS BOOLEAN DEFAULT NULL NOT NULL I get this result: 1: Attempt to insert null into a non-nullable column: column: ABOOLS table: BOOLS in statement [ALTER TABLE BOOLS ADD COLUMN ABOOLS BOOLEAN DEFAULT NULL NOT NULL] Which is correct. In fact here the only statement it will take, without a default setting is: ALTER TABLE BOOLS ADD ABOOL BOOLEAN And then yup your right - thee is no way to get a null with the form controls - or display a null atually it seems - attached another file - 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 114304] Default not being set pro perly when creating a boolean field via SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114304 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' - 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 114304] Default not being set pro perly when creating a boolean field via SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114304 --- Additional comments from atjen...@openoffice.org Sat Sep 4 14:59:33 + 2010 --- Sorry for splitting posts - last paragraph(s) should be You can not enter record via the dataview without entering explicitly a value for the boolean field, and the controls do not pick up the default value - but that has always been true I think. In the form you can enter a record without touching the boolean field but then the, when you do so the record is set with a FALSE in the boolean field - BUT - this is because the checkbox field on the form is set to be for TRI-STATE = FALSE - with this setting it is not picking up the default setting from the database. If you open that form and change the setting for that control to TRI-STATE equals TRUE then the control will correctly pick up the default value TRUE and you see at runtime that it will not accept the NULL state, since the table does not accept it - try with a field set to default TRUE and don't add the NOT NULL and you will see the difference in the form is picked up. So there really are two issues here - one the checkbox control does not pickup the table default setting when tri-state = FALSE Two - the checkbox control in the dataview grid is not tri-state = TRUE At least that's how it looks to me. - 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 114304] Default not being set pro perly when creating a boolean field via SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114304 --- Additional comments from atjen...@openoffice.org Sat Sep 4 14:47:51 + 2010 --- Created an attachment (id=71557) bog doc example - 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 114304] Default not being set pro perly when creating a boolean field via SQL
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114304
--- Additional comments from atjen...@openoffice.org Sat Sep 4 14:46:26
+ 2010 ---
Using Ubuntu 10.04, OOo 3.2 (go-oo) and 3.2.1 (vanilla) I find no difference -
Inserts via direct SQL with a default setting is working.
Inserts via data controls under Base not working.
Open the attached file -
To see that SQL inserts are working open the SQL window and enter
INSERT INTO BOOLS ("Alpha") values ('yet another' )
After executing if you open the bools table or form you will see that the
inserted record has the default of TRUE set for the boolean field.
Now open either the table dataview or bools form and try to enter a new record -
you can do so without entering anything in the second "boolean" field - because
the setting on the datasource is set NOT to check for required fields, since the
boolean field is also defaulted NOT NULL.
-
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 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' - 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 User atjensen changed the following: What|Old value |New value Priority|P1|P3 --- Additional comments from atjen...@openoffice.org Fri Sep 3 04:45:33 + 2010 --- @peterdines Which version of Postgres are you connecting up to? Also, I'm changing the priority on this down to a P3 for the moment, as it A) Looks like the same issue found in another connector and already fixed. I don't have a Postgres server that I can connect to at the moment, but will reset things tomorrow and bring one up. Will check both 3.2.1 and the 3.3 developer release at that time. - 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 114273] Query wizard: cannot set more than 2 conditions at "3.Serach conditions "
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114273 --- Additional comments from atjen...@openoffice.org Fri Sep 3 01:08:19 + 2010 --- Sorry to be clear. In Case two - when you move forward in the wizard you see that NO criteria is set. (not now criteria) - 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 114273] Query wizard: cannot set more than 2 conditions at "3.Serach conditions "
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114273 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo 3.3 --- Additional comments from atjen...@openoffice.org Fri Sep 3 01:04:20 + 2010 --- Confirmed w/ OOO330m_5, Lucid 10.04 If you use the wizard and set one selection criteria then all is correct. If you try to set a second or more selection criteria then, in some cases, all the criteria settings are lost. Case 1 - Set a single selection criteria. Use the NEXT button to move through the wizard and verify the criteria was accepted. It is, now if you use the BACK button to go back and add additional criteria, the additional entries will be lost but the initial entry will be retained and will be part of the SQL generated when you execute the wizard. Case 2 - Set more then one selection criteria initially. Use the Next button to move through the wizard and you will see that now criteria is set. If you finish and save at this point the SQL generated does not include any criteria. Case 3 - Set more then one selection criteria initially. Immediately finis and save the query. The SQL generated includes the first selection criteria selected, but none others. - 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 111542] SRB saving takes minutes and eats 50MB memory eachtime
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111542 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Mon Aug 30 04:39:05 + 2010 --- Confirmed - well not minutes but much too long. Go-oo 3.2.1 Lucid 10.04 (didn't try OOO330m5 as the SRB isn't out yet AFAIK) When the report is being saved no other work can be done in OO.o, which is different then if you run the report, where with more recent SRB releases the user can work on other documents. - 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 114189] Base crashes when using q uery filters / sorts on columns created by cor related subqueries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from atjen...@openoffice.org Mon Aug 30 04:08:24 + 2010 --- Using OOO330m5 / Ubuntu 10.04 I can not recreate the issue. @ameliab I am going to go ahead and close this as works for me - because this is about a crash, while the other issues mentioned have been opened. Of course if you are still having problems do change it back. - 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 113149] Error with JDBC connector on SubForm
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113149 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' --- Additional comments from atjen...@openoffice.org Mon Aug 30 03:15:39 + 2010 --- @krikrou1024 this sure looks like a duplicate issue - for some reason I cand fint the other (actually others) and yes as I recall it is fixed in 3.3 or to be at least. - 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 113408] record update database im possible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113408 --- Additional comments from atjen...@openoffice.org Mon Aug 30 02:26:58 + 2010 --- For what it's worth this seems to be a problem that happens, to some people, when they update to 3.2.1- the issue appears to me to be a problem with the index in the 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
[dba-issues] [Issue 113251] Must be able to use Run S QL Command Directly in all views
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113251 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo Later --- Additional comments from atjen...@openoffice.org Mon Aug 30 02:29:14 + 2010 --- Confirmed with 3.2.1 - whether there is resources to fix or not it is still an issue, IMO - taking FS's advice setting to NEW and target ooLater - 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 113300] There is a problem with t he lock file. I can not access tables from ne w or old databases.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113300 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' --- Additional comments from atjen...@openoffice.org Mon Aug 30 02:24:48 + 2010 --- @rafazio Are you still having this problem? If so could you tell me if you are actually connecting to a MySQL database or using an embedded HSQL, from your entry I can't quite tell which it is. Also, if it is an embedded HSQL - then are you loading it from a networked drive or a local drive? - 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 113508] Controls render incorrecl ty when ControlModel.NativeWidgetLook = TRUE f or Gnome 2.30
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113508 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo Later --- Additional comments from atjen...@openoffice.org Mon Aug 30 02:20:01 + 2010 --- OOO330m5 / Lucid 10.04 - problem remains Setting to ooolater - 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 113506] thisDatabaseDocument.Form Documents.getbyName( XX ).open retuns NULL if form is aldready open
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113506 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Mon Aug 30 02:18:44 + 2010 --- Using OOO330m5 / Lucid 10.04 - the problem remains - 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 114016] Hot-keys for copy and pas te do not work in database-table
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114016 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' --- Additional comments from atjen...@openoffice.org Mon Aug 30 01:21:05 + 2010 --- Using go-oo 3.2.1 / Lucid - dbase datasource, Writer file with data controls - I can not duplicate this problem. I'll check 2.4.3 under HP Mi later but only post here if the problem arises there. - 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 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Mon Aug 30 00:44:35 + 2010 --- Confirmed w/ go-00 3.2.1 Windows and Linux - 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 114188] Base query that reference s another query fails if subquery has order by statement
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114188 User atjensen changed the following: What|Old value |New value Issue type|DEFECT|ENHANCEMENT --- Additional comments from atjen...@openoffice.org Mon Aug 30 00:43:38 + 2010 --- OK - seems that is what can happen with two browser windows open at the same time - updated the wrong issue. I am changing this one from a defect to an enhancement request. - 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 114188] Base query that reference s another query fails if subquery has order by statement
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114188 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' - 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 114188] Base query that reference s another query fails if subquery has order by statement
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114188 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Mon Aug 30 00:31:02 + 2010 --- Can confirm using Go-00 3.2.1 in the case of queries with escape prcocessing disabled, the sort and filter functionality does not work. If you open the query designer and execute the query in these cases the GUI actually reflects this as the sort and filter buttons are not enabled. If you run the query directly the GUI elements for sort and filter are enabled but do not function. For a test database see the file attached to issue 114187 - 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 114166] Illegal operation on empt y result set/MySQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114166 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' --- Additional comments from atjen...@openoffice.org Sun Aug 29 00:43:01 + 2010 --- @lamron99 - this is I'm reasonably positive a duplicate of an already reported and fixed for 3.3 issue - I don't have the link of hand, but will find it tomorrow, just to let you know. - 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 113893] How can I close/open a fo rm with a macro
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113893 --- Additional comments from atjen...@openoffice.org Sun Aug 15 14:33:55 + 2010 --- @ianbella - Hi, the issue tracking system is really not the place for support questions. Please go by http://user.services.openoffice.org (pick a forum for your language preference) and do a search - I'm sure you will find your answer. - 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 113894] Macro to Open/Close a for m
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113894 --- Additional comments from atjen...@openoffice.org Sun Aug 15 14:34:17 + 2010 --- @ianbella - You really should not open two issues for this.. - 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 113730] From does not show groupe d objects (compatibility issue)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113730 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' --- Additional comments from atjen...@openoffice.org Mon Aug 9 12:40:24 + 2010 --- Hi - well, I can confirm the problem w/ the attached file (which actually causes a different issue because of the mis-naming...lol) using DEV330m_2 / Ubuntu. - 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 113744] Can not enter data for de cimal column types in dataview window
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113744 Issue #|113744 Summary|Can not enter data for decimal column types in datavie |w window Component|Database access Version|OOO320m2 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Mon Aug 9 12:20:22 + 2010 --- DEV330m_2 / UbuntStudio 10.04 (AMD64) Open the attached file, open the dataview window for the single table. Try to enter a record, with data in the column Val2 having some decimal value - it generates a java error. Works fine with OO.o3.2 / Ubuntu - 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 113744] Can not enter data for de cimal column types in dataview window
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113744 User atjensen changed the following: What|Old value |New value Keywords| |regression - 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 113744] Can not enter data for de cimal column types in dataview window
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113744 --- Additional comments from atjen...@openoffice.org Mon Aug 9 12:21:06 + 2010 --- Created an attachment (id=71020) example 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
[dba-issues] [Issue 113631] Some Fields Not Displayin g Properly in Subforms
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113631 --- Additional comments from atjen...@openoffice.org Wed Aug 4 18:53:37 + 2010 --- I can add - if you remove the table alias the error clears - which is also a way of saying can confirm this issue with the query parser using OOO330m_2 / Ubuntu. -but as I say, if I change the query from SELECT "Name", "ClientID" FROM "Clients" "ClientID" to SELECT "Name", "ClientID" FROM "Clients" or even SELECT "Name", "ClientID" FROM "Clients" AS "Clients" then this simple query, at least, runs as expected with escape processing enabled. - 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 113552] SubForms are not working at all in newer versions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113552 --- Additional comments from atjen...@openoffice.org Sat Jul 31 09:34:13 + 2010 --- Created an attachment (id=70904) suggested fix - 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 113552] SubForms are not working at all in newer versions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113552 --- Additional comments from atjen...@openoffice.org Sat Jul 31 09:33:41 + 2010 --- @wilq I made two changes to the file using 3.2 - In the dialog Edit>Database>Advanced Settings I disabled checking for required fields. In the form I changed how the link was formed. I'll attach the file, I think this is what you are looking for given the table structure. - 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 113554] Base crashes after SQL in sert error from a subform when using button ac tions to navigate through parent form records
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113554 --- Additional comments from atjen...@openoffice.org Sat Jul 31 06:10:35 + 2010 --- @ameliab Using the database with OO.o 3.2/Ubuntu is a bit different, the office crashes every time. Using OOO330m_2 (the current development build for 3.3) after input a few records and missing data failed writes for a dozen more as test - no crash ever. Using Ubuntu 3.2 to get the crash to stop - open the database, select the menu Edit>Database>Advanced settings. On the dialog remove the tick mark from the item "Form data input checks ". This stops the crash, the data is never written to the table for a partial record, but it is tossed away, and the main form record pointer moved to the next/prev record. Which I would agree is a design error on Bases default actions in this use case. You can work around it however, see: http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/XRowSetApproveListener.html#approveRowChange But I suppose this issue as to the crash only. - 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 113403] thisDatabaseDocument.clos e crashes office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113403 --- Additional comments from atjen...@openoffice.org Sat Jul 31 02:26:41 + 2010 --- good news / bad news OOO330m_2 / Win7 #PAS8 OOO330m_2 / Ubuntu Studio (AMD64, preemptive kernal, gnome 2.30.2) - Crash - 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 113508] Controls render incorrecl ty when ControlModel.NativeWidgetLook = TRUE f or Gnome 2.30
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113508 Issue #|113508 Summary|Controls render incorreclty when ControlModel.NativeWi |dgetLook = TRUE for Gnome 2.30 Component|Database access Version|OOO330m1 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Thu Jul 29 00:56:01 + 2010 --- Tested w/ OOO330m_2 under Ubuntu Lucid Gnome 2.30 #FAIL OO.o 3.2.1 & 3.2.0 Ubuntu #PASS OOO330m_2 Vista #PASS To reproduce this use the attached bug document from http://www.openoffice.org/issues/show_bug.cgi?id=113506 Open the database and enable macros Double click on any row in the grid with a type other then 1. Check out the text in the controls. Close the detail form Close the Main form Open the Basic editor, In the embedded library, module 'NativeLook', function LoadFormNative comment out this line: setNativeWidgetLook( oForm.Drawpage.Forms(0), True ) Open the Biblio form again and then double click on the grid to open a detail form. I suppose NativeWidgetLook is still 'unpublished'..but didn't check the api docs. Still it is a regression from 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 113506] thisDatabaseDocument.Form Documents.getbyName( XX ).open retuns NULL if form is aldready open
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113506 User atjensen changed the following: What|Old value |New value Keywords| |regression - 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 113506] thisDatabaseDocument.Form Documents.getbyName( XX ).open retuns NULL if form is aldready open
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113506 --- Additional comments from atjen...@openoffice.org Wed Jul 28 22:52:12 + 2010 --- Created an attachment (id=70870) bug doc - 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 113506] thisDatabaseDocument.Form Documents.getbyName( XX ).open retuns NULL if form is aldready open
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113506 Issue #|113506 Summary|thisDatabaseDocument.FormDocuments.getbyName( XX ).ope |n retuns NULL if form is aldready open Component|Database access Version|OOO330m1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Wed Jul 28 22:50:54 + 2010 --- Test systems OOO330m_2 / Ubuntu Studio 10.04 (AMD64) & Win Vista (32bit) #FAIL OOo3.2.1, 3.2.0 - #PASS I did not try LoadComponentFromURL against the forms container to see if that changed also. To reproduce load the attached file, with macro execution enabled. On the main form Select any item in the grid Select Article in the drop down list Click 'Edit as' button. Close the form and save the record. This code is run: sub updateBiblio dim bkMark as variant dim oForm as object dim ResultSet as object thisDatabaseDocument.LockControllers oForm = thisDatabaseDocument.FormDocuments.getByHierarchicalName( "Biblio" ).open if not isEmpty( oForm ) then 'xray oForm ResultSet = oForm.Drawpage.Forms.getbyIndex( 0 ) bkMark = ResultSet.getBookMark Resultset.Reload do while NOT ResultSet.isLoaded wait 1 loop ResultSet.moveToBookmark( bkMark ) end if thisDatabaseDocument.UnLockControllers end sub xray oForm returns NULL OBJECT ?? - 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 113403] thisDatabaseDocument.clos e crashes office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113403 --- Additional comments from atjen...@openoffice.org Wed Jul 28 00:12:24 + 2010 --- Checked w/ DEV330m_2 - Vista 32bit - no crash. Haven't checked with Linux yet, will do and post back - 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 113436] when executing prepared s tatement setDate() - object variable not set
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113436 --- Additional comments from atjen...@openoffice.org Tue Jul 27 09:45:53 + 2010 --- Well, I didn't try the setDate just now...but it should take the ISO fomrat. Otherwise, here is an example using the date Structure referenced in the earlier comment. dim dbDate as new "com.sun.star.util.Date" dim ooBasdicDate as Date ooBasdicDate = CDate( strBuff ) dbDate.Month = Month( ooBasdicDate ) dbDate.Year = Year( ooBasdicDate ) dbDate.Day = Day( ooBasdicDate ) Stmt.setdate(10, dbDate) - 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 113436] when executing prepared s tatement setDate() - object variable not set
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113436 --- Additional comments from atjen...@openoffice.org Tue Jul 27 05:37:03 + 2010 --- @jgsylvester Just looking at the basic code it appears that you are getting confused between the setDate function on a date field and setDate for a PreparedStatement date parameter. The later expects the date parameter to be a db date structure - the details can be found in the developer guide API reference: http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XParameters.html#setDate or try using a setString with the format '-MM-DD' and If you have any questions on using the parameter date structure please drop by the user.services.openoffice.org forum or the user mailing list. - 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 113405] Table Grid (based on view ) becoms unstable when records in base table a re updated.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113405 Issue #|113405 Summary|Table Grid (based on view) becoms unstable when record |s in base table are updated. Component|Database access Version|OOo 3.2.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Sun Jul 25 02:01:23 + 2010 --- Error reproduced on Ubuntu 10.04 with vanilla OO.o 3.2.1 and repository 3.2 / also OpenSuse 11.3 repository 3.2.1 To reproduce. Use the attached file from Issue 113403 http://www.openoffice.org/nonav/issues/showattachment.cgi/70804/biblio-hsql-close.odb Open and enable macros. On the default form select any row in the table grid. Select any of the first four items (article, book...) in the list box on the right of the form. Click on the button 'Edit As' Save and close the detail form. Now use the data navigator for the table grid on the original form to move to the last, then first record. OK - a simple refresh (reload) of the dataform attached to the table grid will clear this, so setting the priority to P4, but still. - 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 113403] thisDatabaseDocument.clos e crashes office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113403 --- Additional comments from atjen...@openoffice.org Sun Jul 25 01:36:09 + 2010 --- I suppose it's worth mentioning this issue also http://qa.openoffice.org/issues/show_bug.cgi?id=108524 - 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 113403] thisDatabaseDocument.clos e crashes office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113403 --- Additional comments from atjen...@openoffice.org Sun Jul 25 01:34:03 + 2010 --- Created an attachment (id=70804) Bug document - 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 113403] thisDatabaseDocument.clos e crashes office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113403 Issue #|113403 Summary|thisDatabaseDocument.close crashes office Component|Database access Version|OOo 3.2.1 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Sun Jul 25 01:32:33 + 2010 --- OO.o 3.2.1 (vanilla)/Ubuntu 10.04 AMD64 and OO.o 3.2.1 (repository)/OpenSUSE 11.3 Actually either of these statements cause a crash thisDatabaseDocument.CurrentController.Frame.close( True ) [crash report tracking # rrf4w8n ] or thisDatabaseDocument.close( True ) [crash report tracking # rf84w8n ] will cause a crash. To reproduce download the attached file. Open with macro execution enabled. Close the default form that opens to show the base document window. In the basic editor un-comment the last line in the standard library thisDatabaseDocument.close( True ) Open and close the form "Biblio" Crash - 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 --- Additional comments from atjen...@openoffice.org Wed Jul 7 23:11:59 + 2010 --- @kjonca - Hello. looking at the 2 questions from the last update - if you are planning on binding the column in the the grid to a table field then all you need do is change your basic code, using updateString on the bound field. A work around for, IMO, a defect but it does everything you need. So I would recommend the issue be opened, but set to ooLater, which you can take to be..way later :) On the other hand if you actually want to use the column in the Form UI only, no storage, then I don't think there is a way. So the question becomes, is that something that should be supported. I think so. - 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 --- Additional comments from atjen...@openoffice.org Wed Jul 7 20:50:07 + 2010 --- sorry for the typo - should of been 2 - an unbound text control in a table grid control does not accept input. - 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 --- Additional comments from atjen...@openoffice.org Wed Jul 7 20:48:27 + 2010 --- Well, I suppose a real target would first require a decision as to what (which) is the error this issue will deal with: 1 - setting the text property of a data bound control, embedded in a table grid control does not update the UI (and therefore does not update the bound field, setting the dataforms dirty flag) or 2 - an unbound text control embedded, or control bound to a in a table grid control does not accept any input. - 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
--- Additional comments from atjen...@openoffice.org Wed Jul 7 07:55:24
+ 2010 ---
I took the context of the issue to be: display a string in the column named
'Test' of the table grid control, setting the string with this line from the
basic macro assigned -
tbl.Test.text=tbl.getByName("Notes").text+" Test"
The user is correct, that will not display a string in the column, of the grid
control, on the form. Never has AFAIK
-
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 111977] Office hangs when try to delete all records in table view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111977 User atjensen changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |INVALID --- Additional comments from atjen...@openoffice.org Thu Jun 17 23:55:18 + 2010 --- Well, I can't seem to reproduce this using 3.2.1 at all today. - 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 112450] Using the command line ma cro calling don't work with ODB files
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112450 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW OS/Version|Windows, all |All Summary|Using the command line mac|Using the command line mac |ro calling don't work with|ro calling don't work with | parameter| ODB files --- Additional comments from atjen...@openoffice.org Thu Jun 17 19:32:54 + 2010 --- Confirmed w/ Ubutnu 10.04, OO.o3.2.0 (Ubuntu) & DEV300m_81 I tested this with the macro embedded in the ODB/S file and stored in the stand-alone Standard Library. When the command line opens an ODB file the MACRO option on the command line is ignored. - 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 112160] Save As causes Base to cr ash
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112160 --- Additional comments from atjen...@openoffice.org Mon Jun 7 14:53:40 + 2010 --- @buckwheatpie I'm unable to reproduce the problem using XP and OO.o 3.2 - 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 112100] Text alignment property i gnored by listbox control when embedded in tab le grid control
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112100 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Mon Jun 7 04:43:06 + 2010 --- so set to new and assign to developer... - 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 112100] Text alignment property i gnored by listbox control when embedded in tab le grid control
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112100 User atjensen changed the following: What|Old value |New value OS/Version|Windows Vista |All Summary|Incorrect listbox alignmen|Text alignment property ig |t when list content is SQL|nored by listbox control w | |hen embedded in table grid | | control --- Additional comments from atjen...@openoffice.org Mon Jun 7 04:40:12 + 2010 --- Confirmed w/ OO.o3.2.1 under Ubuntu + MS-Vista - 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 112170] can not connect to HSQLdb file database with JDBC connector
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112170 --- Additional comments from atjen...@openoffice.org Mon Jun 7 00:45:21 + 2010 --- Created an attachment (id=69843) example file - JDBC:hsqldb:file:enrollments - 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 112170] can not connect to HSQLdb file database with JDBC connector
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112170 Issue #|112170 Summary|can not connect to HSQLdb file database with JDBC conn |ector Component|Database access Version|OOo 3.2.1 RC2 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|oj Reported by|atjensen --- Additional comments from atjen...@openoffice.org Mon Jun 7 00:43:55 + 2010 --- To reproduce: Download the attached ODB file Open and try to connect. The file uses JDBC to connect to a HSQLdb file based datasource. Verified issue (inability to connect) with Ubuntu 10.04 (AMD64) + MS-Vista (32bit) using OO.o 3.2.1 Verified that this worked with Ubutnu 10.04 using OO.o3.2 (ooo-build) This is a regression, I'm pretty sure with a closed issue, maybe 3.1.1 release - but I'm not finding it with query..sorry. The reason I think it is a regression of that older issue, same behavior in that if under 3.2.1 you add the hsqldb.jar file explicitly w/OO.o java options - then you can work with external HSQLdb databases via JDBC but not with embedded HSQLdb, which was the behavior before. - 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 112126] Query wizard doesn't keep table relations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112126 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' --- Additional comments from atjen...@openoffice.org Mon Jun 7 00:10:41 + 2010 --- I don't believe this has ever been supported in the Query wizard - ? Seems like a valid enhancement request. - 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 112014] Updates to embedded datab ase not written to file under certain conditio ns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 User atjensen changed the following: What|Old value |New value OS/Version|Linux |All --- Additional comments from atjen...@openoffice.org Sun Jun 6 18:24:54 + 2010 --- Verified the same behavior using MS-Vista (32bit) and OO.o 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 112014] Updates to embedded datab ase not written to file under certain conditio ns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Sun Jun 6 17:54:06 + 2010 --- Currently verified the problem under Ubuntu 10.04 using OO.o 3.2.1 RC2 changed summary - 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 112014] Updates to embedded datab ase not written to file under certain conditio ns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 --- Additional comments from atjen...@openoffice.org Sun Jun 6 17:52:23 + 2010 --- Created an attachment (id=69839) example file - 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 112014] Updates to embedded datab ase not written to file under certain conditio ns
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=112014
User atjensen changed the following:
What|Old value |New value
Summary|Saving of base-files with |Updates to embedded databa
|Linux is behaving strange |se not written to file und
| |er certain conditions
--- Additional comments from atjen...@openoffice.org Sun Jun 6 17:50:18
+ 2010 ---
To reproduce:
Use a BASIC macro to connect to this registered datasource. (DO NOT open the
actual file, just create a connecton)
Update any data.
Close the connection
end the OO.o session.
If no embedded object from the file, or the ODB file, was never opened to the
desktop - then all the changes are lost.
If any GUI object, embedded in the ODB file is opened during the session the
data will be written to the file - even if the updates happened in a macro that
was not called by, or calls, the embedded GUI objects.
For example:
Download the attached file: no-gui.odb
Use the options dialog register the file as no-gui
copy this macro to a library and run it. (remember never actually open the odb
file)
sub test
oContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
db = oContext.getByName("no-gui")
oConn = db.GetConnection ("","")
stmt = oConn.createStatement
stmt.execute( "INSERT INTO ""tblt"" (ID, VAL) VALUES (2, 'sometext')")
end sub
Exit OO.o
Restart OO.o and look at the table in the database, the insert was never written
to disk -
If you did this again, but after running the macro then opening the ODB file.
The data will be written to disk when OO.o session ends, even though via the GUI
the file was never written to disk...
-
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 112014] Saving of base-files with Linux is behaving strange
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 --- Additional comments from atjen...@openoffice.org Sat Jun 5 16:00:54 + 2010 --- Well, figured out the 2 open ODB files. I would say this is a bug in OO.o but it is for sure a bug in the basic code also. The problem is with forming a URL - at one spot in basic code an address of type: /home/yipper/Documents/minutes//TakenDB.odb is used. The URL should of been: /home/yipper/Documents/minutes/TakenDB.odb Now I haven't gone back and checked for sure, but I think in OO.o 3.1.1 this would have caused an error - but it appears that under 3.2 it now actually creates two instances of the document, each instance pointing to the same physical file. Under Windows a lock is placed on the file and OO.o catches this when it creates the second instance of the ODB file in memory. Linux it seems does not place the file lock. Both instances of course use the same HSQLdb lock file. HSQLdb would normally support multiple users, so that makes sense that it works - but OO.o only uses it in single user mode therefore we get the in-memory only behavior for the second connection. @verjon right now I'm going through the basic code and making a few changes, it should be fine with 3.2 after the changes - I'll put another hour to it and then upload the changes as an attachment here for you to look over. - 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 112014] Saving of base-files with Linux is behaving strange
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 --- Additional comments from atjen...@openoffice.org Sat Jun 5 13:48:45 + 2010 --- added a second screen shot: The GUI let me create a second form in the file on the left of the screen. (the original open file) I could then save the file. The GUI also let me add two new forms to the file on the right. (the one opened via the Basic code when the report was run). The GUI does not allow me to save this file. Under Windows, both files can be opened, as here, but the GUI will not allow any changes to the second instance. - 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 112014] Saving of base-files with Linux is behaving strange
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 --- Additional comments from atjen...@openoffice.org Sat Jun 5 13:42:46 + 2010 --- Created an attachment (id=69814) OO.o desktop after editing both open odb files - 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 112014] Saving of base-files with Linux is behaving strange
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 --- Additional comments from atjen...@openoffice.org Sat Jun 5 13:23:22 + 2010 --- Attached a screen shot, Ubuntu Lucid, OO.o3.2.1 RC2 OK - to get this (after installing the extension) start OO.o via sBase directly and open the takenDB.odb working copy.( Double clicking the database copied during install works) open a new text file. Click on 'Run Report' in the extension toolbar. Close the report, and the new text file window. Under Linux you now have two copies of TakenDB.odb opened to the desktop: 1 - I don't think that is correct 2 - unlike MS Windows, under Linux, the GUI does not show the second copy as being opened in Read-Only mode. (though it is in actuality) 3 - Any changes made to the data tables, under Linux and MS Windows, via a connection to the SECOND instance of the TakenDB.odb file is lost when closed. (Changes made to a connection to the first TakenDB.odb file opened are written to disk) - 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 112014] Saving of base-files with Linux is behaving strange
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 --- Additional comments from atjen...@openoffice.org Sat Jun 5 13:06:42 + 2010 --- Created an attachment (id=69813) screen shot - second instance of ODB file opened under Linux - no file lock - 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 112100] Incorrect listbox alignme nt when list content is SQL
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112100 --- Additional comments from atjen...@openoffice.org Sat Jun 5 12:53:18 + 2010 --- Checked w/ OO.o 3.2 & 3.2.1 RC2 - could not reproduce the 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
[dba-issues] [Issue 112014] Saving of base-files with Linux is behaving strange
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 --- Additional comments from atjen...@openoffice.org Thu Jun 3 00:52:25 + 2010 --- the extension to 3.2.1 RC1 under MS Vista, fre 1.6_20. At first it seems to be working correctly, and is in some ways - but turns out it really is not working entirely properly there is IMO a couple of problems, Linux just to exacerbate the situation. There was some problem with connections and file locking for the ODB file, after a report is displayed for instance..anyway - then Then decided I should update to 3.2.1 RC2 and check it, did and now the extension is no longer saving the data between sessions at all. @verjon This exact extensions was working with 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 112014] Saving of base-files with Linux is behaving strange
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112014 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' --- Additional comments from atjen...@openoffice.org Wed Jun 2 23:03:08 + 2010 --- I can confirm the problem using Ubuntu Lucid (AMD64) w/ ooo-build 3.2 and vanilla 3.2.1 RC2. Same behavior in both. Tried each with JRE 1.6.20 and *.18. OK - I'm also having to add every task twice, meaning that when I use the task dialog and click OK, there dialog just cycles back for input and only after clicking OK a second time will it close. I can then open the table in the TakenDB and see the changes. Close OO.o and restart - the TakenDB database is empty of the updates I added in the last step. Tried working with the ODB file directly and when I do that all changes are written to disk as expected -BUT- well something is really wrong here. I'll go off and try this again under windows, but you say it works with 3.2 there? - 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 111974] Combo boxes displays zero in Base forms
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111974 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' --- Additional comments from atjen...@openoffice.org Tue Jun 1 05:40:51 + 2010 --- Using ooo320m_18 w/ Ubuntu 10.04 and OpenSuse11.2 I can not reproduce a problem with the bug doc. - 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 111977] Office hands when try to delete all records in table view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111977 Issue #|111977 Summary|Office hands when try to delete all records in table v |iew Component|Database access Version|OOo 3.2.1 RC2 Platform|Unknown URL| OS/Version|Linux Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|oj Reported by|atjensen --- Additional comments from atjen...@openoffice.org Tue Jun 1 03:35:07 + 2010 --- To reproduce open any ODB file, any table with more then one record. Use the mouse to click the upper left corner of the data grid, so to select all of the available rows. Type [DEL] Proceed past dialog to delete all rows Office hangs Checked w/ Ubuntu 10.04, OOO320m_18 and OpenSUSE 11.2 ooo-build 3.2.1.2 [NOTE under the ooo-build, build one time the odb file was left damaged - I have tried a few times to reproduce that both with the ooo-build and the vanilla build. I've not been able to reproduce it again...but the hang is constant in both] - 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 111977] Office hands when try to delete all records in table view
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111977 User atjensen changed the following: What|Old value |New value Keywords| |regression --- Additional comments from atjen...@openoffice.org Tue Jun 1 03:35:48 + 2010 --- Verified that this was working with 3.2 - adding keyword regression - 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 111959] Subform with tablegrid do es not work anymore
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111959 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords| |regression OS/Version|Windows XP|All --- Additional comments from atjen...@openoffice.org Tue Jun 1 02:34:19 + 2010 --- Confirmed w/ Ubuntu 10.04, OOO320m_18 Verified that the form functions properly with 3.2 - 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 111828] Incomplete header in Base query views with 'Count' function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111828 User atjensen changed the following: What|Old value |New value OS/Version|Windows XP|All --- Additional comments from atjen...@openoffice.org Wed May 26 16:21:27 + 2010 --- also checked w/ OO.o3.2.1 RC2 (OOO32m_18), Ubuntu 10.04 - 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...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 111828] Incomplete header in Base query views with 'Count' function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111828 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo 3.3 --- Additional comments from atjen...@openoffice.org Wed May 26 15:53:41 + 2010 --- Confirmed w/ OO.o3.2.1 RC1, MS Vista I used a half dozen different functions but only COUNT seems to clip the string for the column name. @jimmyjazz setting an alias explicitly, even one such as 'COUNT( COL )', does work around this issue, so setting target to 3.3 and not 3.2.1 - the issue is IMO too minor to delay the 3.2.1 release. assigning to developer - 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 111737] average value does not di splay in openoffice.org base report
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111737 User atjensen changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from atjen...@openoffice.org Sun May 23 22:07:36 + 2010 --- Thanks - ok, sorry I should of caught this at first. When you construct your SQL statement the command is AVG( colName ) and not AVERAGE. [note in your example file there is also a typo in the table name, also] With the SQL statment corrected the report runs here (Lucid 10.04 AMD64 - Ubuntu OO.o 3.2) without a problem. Setting issue to WORKSFORME - 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 111737] average value does not di splay in openoffice.org base report
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111737 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' --- Additional comments from atjen...@openoffice.org Sun May 23 18:47:05 + 2010 --- Hi - I'm having a hard time trying to reproduce what you are doing, it doesn't seem like something that should work at all..any chance you upload a copy of the database file with the report? - 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 111775] Can't paste to Base form
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111775 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' - 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 111624] OOo crashes with invalid SET TABLE INDEX statement in script file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111624 User atjensen changed the following: What|Old value |New value CC|'r4zoli' |'atjensen,r4zoli' Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Summary|OOo crashes on clicking Ta|OOo crashes with invalid S |bles view in Base |ET TABLE INDEX statement i | |n script file --- Additional comments from atjen...@openoffice.org Mon May 17 19:07:50 + 2010 --- OO.o crashes when during initialization of the HSQL engine an invalid ALTER TABLE INDEX statement is executed. The command that causes the crash is embedded in the attached test document. In the embedded script file, within the ODB file is this line: SET TABLE "Transactions" INDEX'87920 90456 86704 89512 43' Which brings the question; What sequence of steps causes that invalid line to end up in the script file? - 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 111465] Paste from Calc to Base t able ignores current clipboard contents
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111465 --- Additional comments from atjen...@openoffice.org Sat May 8 15:32:05 + 2010 --- Checked this with OO.o 3.2 under Vista and Ubuntu 10.04 and could not reproduce the problem. Both cases however I used the embedded HSQl driver - I will try on XP against a SQlite/ODBC connection also. - 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 atjensen changed the following: What|Old value |New value CC|''|'atjensen' Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo 3.3 --- Additional comments from atjen...@openoffice.org Tue May 4 11:06:52 + 2010 --- confirmed w/ OOo3.2, OOO320m_16 and DEV300m_77 set initial target - 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 110582] impossible to create a ne w item in a base with
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110582 --- Additional comments from atjen...@openoffice.org Tue May 4 05:44:17 + 2010 --- ok - I think I'm with you now. I can open the forms against non-existent tables, and there I guess is the problems, the filter statements on the dataforms. this is a problem with 3.2 in general, not just when connected to postgres. Before I mark as a duplicate though - you say that you modify the forms to work in 3.2, is that modification for the filter statements? - 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 110582] impossible to create a ne w item in a base with
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=110582
User atjensen changed the following:
What|Old value |New value
CC|'r4zoli' |'atjensen,r4zoli'
--- Additional comments from atjen...@openoffice.org Sun May 2 20:12:26
+ 2010 ---
Ran the following:
Ubuntu studio 10.04 (pretty much new)
Installed Postgresl 8.4 and 8.4-701 JDBC connector.
Created a new database/schema/user
then created a table in the pgAdmin as:
-- Table: msis.pgadm_table1
-- DROP TABLE msis.pgadm_table1;
CREATE TABLE msis.pgadm_table1
(
id serial NOT NULL,
val character varying,
num numeric,
CONSTRAINT pgadm_table1_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE msis.pgadm_table1 OWNER TO "OOo_Admin";
Then used OO.o 3.2 from the Ubuntu build and created a connection then created
the a table definition using Base GUI: this is geneerated:
-- Table: msis."Table1"
-- DROP TABLE msis."Table1";
CREATE TABLE msis."Table1"
(
id integer NOT NULL DEFAULT nextval('msis."Table1_id_seq"'::regclass),
val character varying,
num numeric,
CONSTRAINT "Table1_pkey" PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE msis."Table1" OWNER TO "OOo_Admin";
OK then trying to add data using
OO.o 3.2 from Ubuntu
OO.o 3.2 m_12 Vanilla
OOO320m_16 and DEV300m_17
- no problem adding data to either table.
-
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 108390] "No data availlable" for subform
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108390 User atjensen changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from atjen...@openoffice.org Sun May 2 14:29:49 + 2010 --- Checked this for the specific case of a single dataform, form, set for 'new record only' with OOO320m_16 under Ubuntu and Vista. That works now, no problems. Also checked DEV300m_77 under both OS - no 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
[dba-issues] [Issue 108390] "No data availlable" for subform
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108390 --- Additional comments from atjen...@openoffice.org Sun May 2 14:21:33 + 2010 --- *** Issue 111297 has been marked as a duplicate of 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
[dba-issues] [Issue 111297] Form created with wizard for only insert data error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111297 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from atjen...@openoffice.org Sun May 2 14:21:36 + 2010 --- Duplicate issue - *** This issue has been marked as a duplicate of 108390 *** - 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 111303] OOo does not show SQL err or in filtered form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111303 --- Additional comments from atjen...@openoffice.org Sun May 2 14:16:15 + 2010 --- also- just checked this with the QA-upload build of OOO320m_16 from last week- same 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
[dba-issues] [Issue 111303] OOo does not show SQL err or in filtered form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111303 User atjensen changed the following: What|Old value |New value CC|'vitriol' |'atjensen,vitriol' Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW OS/Version|Windows XP|All Priority|P2|P3 --- Additional comments from atjen...@openoffice.org Sun May 2 14:09:22 + 2010 --- Confirmed w/ OOo 3.2 and OOO320m_16 under Ubuntu 10.04 and Vista DEV300m_77 under Ubuntu and Vista displays an error dialog listing, correctly, the missing column name in the filter is displayed. Lowered the priority as there is not a loss of data here. - 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 111143] Certain Column names can cause silent errors during data posting causin g data to written to wrong columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj --- Additional comments from atjen...@openoffice.org Sun Apr 25 22:35:10 + 2010 --- assign to developer - 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 111143] Certain Column names can cause silent errors during data posting causin g data to written to wrong columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43 --- Additional comments from atjen...@openoffice.org Sun Apr 25 22:32:31 + 2010 --- Created an attachment (id=69104) example file with single table - bad column names - 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 111143] Certain Column names can cause silent errors during data posting causin g data to written to wrong columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43 Issue #|43 Summary|Certain Column names can cause silent errors during da |ta posting causing data to written to wrong columns Component|Database access Version|OOO320m15 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Sun Apr 25 22:31:30 + 2010 --- Could reproduce with OO.o 3.1.1 onwards (probably before) For example if a user creates 2 columns with names that differ only in case: T-Pain and T-PAIN This is valid for HSQLdb, and Base data controls will appear to work these columns, but during an update to the table the data is shifted to erroneous columns, for columns following the second instance of case insensitive string. If the data types of the misaligned data write are compatible, no error is given to the user - with one exception. There is a hint in the GUI when this is about to happen, the record number in the navigation bar will become inaccurate (always changing to 1) when a new value is written to a controls attached to one of these 'special' columns. NOTE - it appears that other strings can cause this also 'some:thing' and 'some/thing' may trigger it. To see this in action download the attached file, open the SOAP table in a dataview window - now near go to the end of the record, you will find the columns: Dx1, Dx2...Dx6 - write a value into these controls and update the table, you will see that the data moves to the right...on a forum with a lot of CHECKBOX controls this silent change can go on without catching the users attention. - 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 111142] Ofice crashes if you try to create too many columns in a table
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42 Issue #|42 Summary|Ofice crashes if you try to create too many columns in | a table Component|Database access Version|OOO320m15 Platform|Unknown URL| OS/Version|Windows, all Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Sun Apr 25 22:11:25 + 2010 --- Crash happens in OOO320m_15 and DEV300m_77 Open the attached file. Open the SOAP table in 'Edit Definition' view. Right click on the column grid marker area and select 'Insert Row' from context menu. CRASH - no error report, error recovery on restart is started. - 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 111142] Ofice crashes if you try to create too many columns in a table
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42 --- Additional comments from atjen...@openoffice.org Sun Apr 25 22:12:16 + 2010 --- Created an attachment (id=69103) example file - 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 111125] Form data grid heading di storted during opening process
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=25 User atjensen changed the following: What|Old value |New value OS/Version|Windows 7 |All --- Additional comments from atjen...@openoffice.org Sat Apr 24 19:19:32 + 2010 --- confirmed w/ OOO300m_77, Ubuntu Studio 10.04 (current today) - 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
