Bug 87737 - EDITING: Date-parameter in queries don't work in UI-language, if parameter is only in subquery
Summary: EDITING: Date-parameter in queries don't work in UI-language, if parameter is...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-12-26 07:13 UTC by robert
Modified: 2015-01-03 17:39 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:

Attachments
Try input date in the parameter for both queries. One works in GUI-language, the other doesn't. (6.66 KB, application/vnd.oasis.opendocument.base)
2014-12-26 07:13 UTC, robert 		Details
View All

Description robert 2014-12-26 07:13:47 UTC 
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
Comment 1 raal 2014-12-30 12:52:38 UTC 
I can confirm with LO 4.3.5, win7
Comment 2 Alex Thurgood 2015-01-03 17:39:06 UTC 
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.