[dba-issues] [Issue 109185] time field cannot read Or acle type DATE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109185 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Wed Jul 21 10:23:53 + 2010 --- worksforme - closed - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109185] time field cannot read Or acle type DATE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109185 --- Additional comments from eberl...@openoffice.org Wed Jul 21 10:42:19 + 2010 --- Really necessary to open a new issue? Did you try my approach? See attachment. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109185] time field cannot read Or acle type DATE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109185 --- Additional comments from eberl...@openoffice.org Wed Jul 21 10:44:00 + 2010 --- Created an attachment (id=70747) Snapshot to reproduce - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109185] time field cannot read Or acle type DATE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109185 --- Additional comments from eberl...@openoffice.org Tue Jul 6 07:41:50 + 2010 --- I selected another approach (with m84). There's is an existing table with type DATE (Oracle 10g). Created a form with a date field and a time field. Date field shows the correct value. Time field shows 00:00. Modified the time and changed the record. The date field shows 01.01.1800. Pressed the SAVE button: throws an java.lang.IllegalArgumentException. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109185] time field cannot read Or acle type DATE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109185 User oj changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from o...@openoffice.org Tue Jul 6 05:44:33 + 2010 --- I can not reproduce it in DEV300_m84. I did the following - create a table with a date column - inserted some values - create a form with a time field - updated the value (only the time value) = the value was correctly updated - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109185] time field cannot read Or acle type DATE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109185 User oj changed the following: What|Old value |New value CC|''|'oj' --- Additional comments from o...@openoffice.org Tue Jul 6 05:46:15 + 2010 --- add myself - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109185] time field cannot read Or acle type DATE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109185 Issue #|109185 Summary|time field cannot read Oracle type DATE Component|Database access Version|OOo 3.2 RC5 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|eberlein --- Additional comments from eberl...@openoffice.org Fri Feb 12 08:28:04 + 2010 --- Though Oracle stores date values always with hh:mm:ss, a time field cannot read and write this information. So you have to use always a TimeStamp field 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org