When I try to open a query with parameters, I get the following error:
"Die Dateninhalte konnten nicht geladen werden.", which means something like "data could not be loaded".
*Dynamic SQL Error
*SQL error code = -206
*At line 1, column 9406
The query is something like "SELECT * FROM "query1" WHERE "dt" >= :FROM_DATE AND "dt" <= :TO_DATE". There is even the popup dialog that allows me to enter dates for the parameters, but then the error is shown.
Happens with 6.1.0rc2 and 6.1.0.beta1. Does not happen with 6.0.5.
I haven't been able to reproduce this with a simple database document, yet. I cannot send the original one. I use a cascade of queries. I am still trying to simplify this.
Could be the same reason Firebird doesen't work with subforms (LO 184.108.40.206). See bug 118112.
Thanks for the hint. I will try with the macro from https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c11
(In reply to Gerhard Schaber from comment #2)
> Thanks for the hint. I will try with the macro from
Yes, it changes after https://cgit.freedesktop.org/libreoffice/core/commit/?id=a29d97e6ddab8ec002ba9827bd5fc874117712e0.
Please, follow the steps in https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c11 and it should work afterwards...
Closing as RESOLVED DUPLICATED
*** This bug has been marked as a duplicate of bug 117053 ***