On 02/21/2013 11:46 AM, Robert Großkopf wrote:
Hi *,
is there anybody, who could have a look at
https://bugs.freedesktop.org/show_bug.cgi?id=61166 ?
EDITING: Values in correlated subquery were not shown in queries.
You only have to download a file and start two queries. With LO up to
3.6 you see values in the field "Balance", with 4.0 this part of the
query is empty.
For me its a greater problem of Base - no dataloss, but unusable forms,
which worked since the beginning of LO.
Regards,
Robert
The problem is how the Query Design dialog runs the query. What I
discovered is that if I opened the query to edit it in Design view that
I got an error message: "SQL syntax error". When I opened either query
in SQL view and clicked the icon that has SQL in it ("Run SQL command
directly"), I could run the query correctly. The Balance column then
contained the same values as when I ran the query using LO 3.6.5.2.
I also added comments similar to these in the bug report.
--Dan
_______________________________________________
List Name: Libreoffice-qa mailing list
Mail address: [email protected]
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
