2010.03.18. 20:47 keltezéssel, Drew Jensen írta:
On 3/18/2010 2:56 PM, Reizinger Zoltán wrote:
2010.03.18. 16:27 keltezéssel, Drew Jensen írta:
Is there anyone on the list that could look at this issue:
http://qa.openoffice.org/issues/show_bug.cgi?id=108415
Specifically with OO.o 3.2 w/ De or Es language packs.
I tried this on Hu version and En of OOo and my problem with SQL syntax
used in queries.
Queries works in same way, throw exception when try to use YYYY or DD as
wildcard in query conditions, as
in this example: ..... WHERE ( "Table1"."Pvm"<= {D 'YYYY-01-DD 00:00:00'
} )
This method is not usable in queries, if I know well.
The issue seems to me is invalid.
Correct me if I wrong.
Hello Zoltan,
I believe the issue was that when the query wizard was used to
construct the SQL, that when certain language packs where used the
query was defective.
so I have a table with fields ID, D1, dt (where dt is a TimeStamp field)
When I entered data in the dt field I only entered dates, no times so
all the data is dd/mm/yy 00:00:00
Using the query wizard I select the table, select all the fields and
on the wizard tab for adding the where clause I select the field dt
and add a condition again only entering a date. No time value.
Using DEV300m_75 en I get this SQL statement from the wizard:
SELECT "Table1"."id" AS "id", "Table1"."D1" AS "D1", "Table1"."dt" AS
"dt" FROM "Table1" "Table1" WHERE ( "Table1"."dt" > {D '2010-01-15
00:00:00' } )
If I understand the reporter(s) issue, using a De or Es one gets the
errant SQl, such as you describe.
Does make sense?
Yes, now I read issue text again and more carefully.
I can confirm the issue.
I installed Finnish langpack, and the query wizard created erroneous
values in query, I added date in wizard, and get letters mixed in.
The platform was opensuse 11.2, i586 - original issue submitted on win7,
it is on all platform issue.
I tested with Hungarian and Russian langpack, no such problems.
I have no idea whom to assign this, please do it.
Zoltan
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
