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?
Thanks
Drew
(only a few more issues off the unconfirmed list and a new selection of
music.... *smile*)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org