[dba-issues] [Issue 95443] changing a field in a tabl e to date format fails if it's not empy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95443 User clu changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from c...@openoffice.org Wed Mar 4 13:10:22 + 2009 --- => close - 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 95443] changing a field in a tabl e to date format fails if it's not empy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95443 User clu changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from c...@openoffice.org Wed Mar 4 13:09:52 + 2009 --- thx drew for the try & explanation - 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 95443] changing a field in a tabl e to date format fails if it's not empy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95443 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' --- Additional comments from [EMAIL PROTECTED] Mon Oct 27 13:24:02 + 2008 --- Well, this is actually a function of the HSQLdb database engine not Base per se. Also, your description is not completely accurate. The reason for the failure to convert was not because of 'data' in the field, rather because of the data's format. For instance using your steps, if in the VARCHAR field you had entered the string '2002-02-02' the conversion to DATE type would execute without a problem. The HSQLdb engine has specific rules for data transformations such as this, to the best of my knowledge there is nothing in Base that breaks the rules as they would apply to any instance of any HSQLdb 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 95443] changing a field in a tabl e to date format fails if it's not empy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95443 --- Additional comments from [EMAIL PROTECTED] Sat Oct 25 17:59:20 + 2008 --- Created an attachment (id=57455) example, open the table and try to change the "date" field to DATE type, - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 95443] changing a field in a tabl e to date format fails if it's not empy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95443 Issue #|95443 Summary|changing a field in a table to date format fails if it |'s not empy Component|Database access Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|sladivadi --- Additional comments from [EMAIL PROTECTED] Sat Oct 25 17:57:27 + 2008 --- create a new database create a table in (design view) create an id field create a data field and change format to DATE create a data field and leave format as VARCHAR open the save table again and enter the same dates in the fields (02.02.02 in text and 2-2-2 in the date formatted field) save, close and edit the table and try to change the VARCHAR field to DATE saving fails because it can't change the field type to DATE Regards, Sladi - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]