To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49043
------- Additional comments from [EMAIL PROTECTED] Wed May 25 10:41:00 -0700 2005 ------- Have installed 1.9.104 and tested date columns with UniVerse JDBC in query tool. Although date columns are still incorrectly shown as text[varchar] when editing table definitions, a query can be created (with limitations) that does display date columns correctly and I wonder if this might shed some light on why OOo "loses" the date definition once a table is created and one reconnects to the database as previously reported. For example: If a query is created in design view, date columns are displayed as an integer which does not appear to have a relationship to the actual date. EG. SELECT "NAME1", "DATE.OPENED" FROM "CM" ORDER BY "DATE.OPENED" ASC NAME1 |DATE.OPENED| SHOPRITE|25567 | On switching Design Mode off and running the SQL "directly" the date columns display as the correct date eg. SHOPRITE|01/01/70 However by switching to "Run SQL command directly" mode one cannot then use "?" to parameterise the criteria for selection. So although the table definition seems to remain incorrectly interpreted as text for date columns, the query tool can interpret date columns correctly. Could the fact that running a query in "direct" mode correctly handles dates, albeit without the ability to prompt for criteria, throw some light on the reason for OOo and UniVerse not understanding/interpreting certain data types. --------------------------------------------------------------------- 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]
