[dba-issues] [Issue 116243] execution of database operations measurably slower in Ubuntu than Windows

2011-01-23 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116243 --- Additional comments from jgsylves...@openoffice.org Sun Jan 23 13:20:13 + 2011 --- I am running Java 1.6.0_23 on Ubuntu. It does not make a difference. If t

[dba-issues] [Issue 116243] execution of database operations measurably slower in Ubuntu than Windows

2011-01-22 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116243 --- Additional comments from jgsylves...@openoffice.org Sat Jan 22 17:22:52 + 2011 --- My computer is an 64-bit Desktop HP Pavilion a6430f 3-core processor run

[dba-issues] [Issue 116399] Can no longer format bool ean field as check box in OOo 3.3 RC Base repo rts

2011-01-11 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116399 --- Additional comments from jgsylves...@openoffice.org Tue Jan 11 15:10:09 + 2011 --- Created an attachment (id=75538) database Accounts that contain report wi

[dba-issues] [Issue 116399] Can no longer format bool ean field as check box in OOo 3.3 RC Base repo rts

2011-01-11 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116399 --- Additional comments from jgsylves...@openoffice.org Tue Jan 11 15:08:08 + 2011 --- I have a database created in OOo Base 3.2 that has one table, "Accounts".

[dba-issues] [Issue 116399] Can no longer format bool ean field as check box in OOo 3.3 RC Base repo rts

2011-01-10 Thread jgsylvester
Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Mon Jan 10 21:19:19 + 2011 --- I used to be able to create a report in OOo Base 3.2.1 (without

[dba-issues] [Issue 116243] execution of database ope rations measurably slower in Ubuntu than Windo ws

2010-12-29 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116243 --- Additional comments from jgsylves...@openoffice.org Wed Dec 29 13:21:55 + 2010 --- On Ubuntu 10.10, I am using 64-bit Ubuntu. However on Windows, it is 32-b

[dba-issues] [Issue 116243] execution of database ope rations measurably slower in Ubuntu than Windo ws

2010-12-28 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116243 --- Additional comments from jgsylves...@openoffice.org Tue Dec 28 11:11:59 + 2010 --- Created an attachment (id=75431) database Inventory that measures elapsed

[dba-issues] [Issue 116243] execution of database ope rations measurably slower in Ubuntu than Windo ws

2010-12-28 Thread jgsylvester
Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Tue Dec 28 11:09:50 + 2010 --- I have a database, Inventory, created in OOo Base 3,2 or earlier. When

[dba-issues] [Issue 115629] OOo 3.3 RC4 Base crashes when standard filter applied

2010-11-17 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115629 --- Additional comments from jgsylves...@openoffice.org Wed Nov 17 09:58:34 + 2010 --- Created an attachment (id=75028) database created from Thunderbird data s

[dba-issues] [Issue 115629] OOo 3.3 RC4 Base crashes when standard filter applied

2010-11-17 Thread jgsylvester
Subcomponent|none Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Wed Nov 17 09:56:28 + 2010 --- I have created a database using OOo 3.3 RC4. This database was created from using Mozilla Thunderbird 3.1.6 as

[dba-issues] [Issue 115380] executeUpdate() does not work in OOo 3.3 RC3 Base

2010-11-03 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115380 User jgsylvester changed the following: What|Old value |New value

[dba-issues] [Issue 115380] executeUpdate() does not work in OOo 3.3 RC3 Base

2010-11-03 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115380 --- Additional comments from jgsylves...@openoffice.org Wed Nov 3 16:21:05 + 2010 --- Created an attachment (id=72841) database exhibiting error

[dba-issues] [Issue 115380] executeUpdate() does not work in OOo 3.3 RC3 Base

2010-11-03 Thread jgsylvester
Subcomponent|none Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Wed Nov 3 15:58:04 + 2010 --- I receive the following error when executing an "executeUpdate()" statement: "BASIC ru

[dba-issues] [Issue 115354] Printing report build wit h SRB crashes Base 3.3.0 RC3

2010-11-02 Thread jgsylvester
Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Tue Nov 2 11:13:04 + 2010 --- I have upgraded to Openoffice.org 3.30 RC 3 on both Windows(Vista) and Linux (Ubuntu 10.10). I am attempting to print

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 11:13:07 + 2010 --- I verified your workaround does indeed work in OOo 3.3.0, but not OOo 3.2

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 11:01:40 + 2010 --- Are you sure this works? I copied your workaround into the database, and

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:47:46 + 2010 --- Created an attachment (id=72129) Incorrect.pgn - results from query when

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:46:29 + 2010 --- Here is screenshot of query results when NULL is replaced by 0.

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:43:27 + 2010 --- Created an attachment (id=72128) Correct.pgn screenshot of good results f

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:41:19 + 2010 --- I am attaching a screenshot of what the query "NEW Averages By Month" sho

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:13:06 + 2010 --- Just for the record, replacing NULL with 0 in my queries allows the queri

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 07:43:17 + 2010 --- It seems that my queries that are failing are due to NULL not being valid

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 07:16:29 + 2010 --- I eill attach my database Blood Sugars. There are a lot of queries, most

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-21 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 07:18:14 + 2010 --- Created an attachment (id=72125) Blood Sugars.odb -

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

2010-10-20 Thread jgsylvester
Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 02:11:54 + 2010 --- I upgraded to OpenOffice.og 3.3.0 Release

[dba-issues] [Issue 114905] ExecuteQuery does not wor k when called from a Basic macro

2010-10-04 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114905 User jgsylvester changed the following: What|Old value |New value

[dba-issues] [Issue 114905] ExecuteQuery does not wor k when called from a Basic macro

2010-10-04 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114905 --- Additional comments from jgsylves...@openoffice.org Mon Oct 4 16:43:14 + 2010 --- I am able to reproduce these symptoms with OOo 3.2.1 running under Window

[dba-issues] [Issue 114905] ExecuteQuery does not wor k when called from a Basic macro

2010-10-04 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114905 --- Additional comments from jgsylves...@openoffice.org Mon Oct 4 12:51:21 + 2010 --- I upgraded to OOo 3.2.1 from http://ppa.launchpad.net/openoffice-pkgs/ppa

[dba-issues] [Issue 114905] ExecuteQuery does not wor k when called from a Basic macro

2010-10-03 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114905 --- Additional comments from jgsylves...@openoffice.org Sun Oct 3 17:21:39 + 2010 --- Created an attachment (id=71928) Database Dialysis

[dba-issues] [Issue 114905] ExecuteQuery does not wor k when called from a Basic macro

2010-10-03 Thread jgsylvester
Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Sun Oct 3 15:59:38 + 2010 --- I have a database "Dialysis" built in OOO base 3.2.1 run

[dba-issues] [Issue 113436] when executing prepared s tatement setDate() - object variable not set

2010-07-27 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113436 User jgsylvester changed the following: What|Old value |New value

[dba-issues] [Issue 113436] when executing prepared s tatement setDate() - object variable not set

2010-07-27 Thread jgsylvester
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 jgsylves...@openoffice.org Tue Jul 27 06:57:45 + 2010 --- I added a Dim MyDate As Date statement. I set MyDate to "1998-07-01" with

[dba-issues] [Issue 113436] when executing prepared s tatement setDate() - object variable not set

2010-07-26 Thread jgsylvester
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 jgsylves...@openoffice.org Tue Jul 27 06:41:08 + 2010 --- I have tried every combination of date string: '-MM-DD', 'MM-DD-"

[dba-issues] [Issue 113436] when executing prepared s tatement setDate() - object variable not set

2010-07-26 Thread jgsylvester
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 jgsylves...@openoffice.org Mon Jul 26 16:22:21 + 2010 --- Created an attachment (id=70826) Database file DB1

[dba-issues] [Issue 113436] when executing prepared s tatement setDate() - object variable not set

2010-07-26 Thread jgsylvester
Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Mon Jul 26 16:19:14 + 2010 --- Database DB1 has Basic macro "insertRecordsFromFile

[dba-issues] [Issue 111974] Combo boxes displays zero in Base forms

2010-05-31 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111974 --- Additional comments from jgsylves...@openoffice.org Mon May 31 23:45:17 + 2010 --- Created an attachment (id=69743) Database file "Medical.odb" --

[dba-issues] [Issue 111974] Combo boxes displays zero in Base forms

2010-05-31 Thread jgsylvester
Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Mon May 31 23:43:46 + 2010 --- I have a database "Medical" created in Openoffice.org base 3.2.0. I am currently running OO base 3.2.1 RC2, t

[dba-issues] [Issue 111737] average value does not di splay in openoffice.org base report

2010-05-23 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111737 --- Additional comments from jgsylves...@openoffice.org Sun May 23 22:36:09 + 2010 --- Thanks for resolving this issue. I am somewhat concerned: how is the user

[dba-issues] [Issue 111737] average value does not di splay in openoffice.org base report

2010-05-23 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111737 --- Additional comments from jgsylves...@openoffice.org Sun May 23 21:04:18 + 2010 --- Created an attachment (id=69593) Database file Blood Sugars.odb ---

[dba-issues] [Issue 111737] average value does not di splay in openoffice.org base report

2010-05-20 Thread jgsylvester
Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Thu May 20 21:31:26 + 2010 --- I have a database created in Openoffice.org Base version

[sc-issues] [Issue 105905] Changes to Format->Print Ranges do not take effect immediately in Page Preview

2009-10-14 Thread jgsylvester
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105905 --- Additional comments from jgsylves...@openoffice.org Wed Oct 14 20:01:56 + 2009 --- I have attached my spreadsheet Prescriptions.ods . Unfortunately, I was o

[sc-issues] [Issue 105905] Changes to Format->Print Ranges do not take effect immediately in Page Preview

2009-10-14 Thread jgsylvester
ECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|jgsylvester --- Additional comments from jgsylves...@openoffice.org Wed Oct 14 17:31:54 + 2009 --- Changes to the print range as defined in Format->Print Ra