| Summary: | EDITING: Date-parameter in queries don't work in UI-language, if parameter is only in subquery | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | robert |
| Component: | Database | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | iplaw67, raal |
| Version: | Inherited From OOo | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | All | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: | Try input date in the parameter for both queries. One works in GUI-language, the other doesn't. | ||
I can confirm with LO 4.3.5, win7 Adding self to CC if not already on |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 111359 [details] 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