https://bugs.freedesktop.org/show_bug.cgi?id=87737
Bug ID: 87737
Summary: EDITING: Date-parameter in queries don't work in
UI-language, if parameter is only in subquery
Product: LibreOffice
Version: Inherited From OOo
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Created attachment 111359
--> https://bugs.freedesktop.org/attachment.cgi?id=111359&action=edit
Try input date in the parameter for both queries. One works in GUI-language,
the other doesn't.
Open the attached database.
Open the query "Saldo_Kategorie".
You are asked for 'qDatum'.
Write a date and finish.
The query would be executed.
Open the query "Saldo_Konto".
You are asked for 'qDatum'.
Write a date and finish.
The query would only be executed, if you will format the date right to the
SQL-standard, something like '2014-12-26'.
The difference between the two queries:
"Saldo_Kategorie" asks for the parameter in the condition of the query:
...FROM "Kasse" AS "a" WHERE "Datum" <= :qDatum AND "Umbuch_Konto_ID" IS NULL
The parameter is also askes for in subqueries, but it works well.
"Saldo_Konto" asks for the parameter only in subqueries and fails wirth
GUI-language, works only with SQL-well-formatted date.
Both queries work right in a form. The date in a form will be transported in
SQL-format.
My system: OpenSUSE 12.3 64bit rpm Linux, different LO-versions, also 4.4.0.1
rc
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
