To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 Issue #|108415 Summary|Query Wizard not working with Date fields in langpacks Component|Database access Version|OOO320m9 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ristoi
------- Additional comments from [email protected] Mon Jan 18 13:00:06 +0000 2010 ------- Query Wizard handles wrongly Dates (or Timestamps) in langpacks. Conditions: Database with Date field. Some other language than english in use. Procedure: Create Query with Query Wizard using search condition with Date field. In my example field Pvm has format: Date[DATE]. Here is some results as SQL: English: SELECT "Table1"."ID" AS "ID", "Table1"."First" AS "First", "Table1"."Other" AS "Other", "Table1"."Pvm" AS "Pvm" FROM "Table1" "Table1" WHERE ( "Table1"."Pvm" <= {D '2010-01-02 00:00:00' } ) Obervation: there is no letters from date format code and query is working. Swedish: SELECT "Table1"."ID" AS "ID", "Table1"."Other" AS "Other", "Table1"."Pvm" AS "Pvm" FROM "Table1" "Table1" WHERE ( "Table1"."Pvm" <= {D '2010-01-02 HH:00:00' } ) Obervation: there is letters from date format code(?) only in the time part and query is working with date field. With Timestamps it is not working. German: SELECT "Table1"."ID" AS "ID", "Table1"."First" AS "First", "Table1"."Other" AS "Other", "Table1"."Pvm" AS "Pvm" FROM "Table1" "Table1" WHERE ( "Table1"."Pvm" <= {D 'YYYY-01-DD 00:00:00' } ) Obervation: there is letters from date format code(?) only in the date part and query is not working with date field. Finnish: SELECT "Table1"."ID" AS "ID", "Table1"."First" AS "First", "Table1"."Other" AS "Other", "Table1"."Pvm" AS "Pvm" FROM "Table1" "Table1" WHERE ( "Table1"."Pvm" <= {D 'YYYY-00-DD HH:00:00' } ) Obervation: there is letters from date format code(?) both in the date part and the time part and month is replaced with "00". Query is not working with date field. It is possible that this is problem with localizations. But at least is seem to be very easy to make national bugs here. So some help is needed for localizations? As far as I know original language of database make no difference. Paremman huomisen toivossa Risto Jääskeläinen --------------------------------------------------------------------- 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]
