https://bugs.documentfoundation.org/show_bug.cgi?id=120187
Bug ID: 120187
Summary: Error message handling checkbox criterion building
Query in Design View
Product: LibreOffice
Version: 6.1.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: zoom...@gmx.com
Description:
I want to emphasize that this works in Ubuntu, but not in Windows 8.1 x64.
Say I have a checkbox field in my table called Cancelled. I want the query to
list all the cancelled items. I put a "1" or "=1" in the criterion in the
Cancelled column.
I get the following error message:
The data content could not be loaded
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'
Yet it works in Ubuntu. I have no idea what the error message means.
Steps to Reproduce:
1.Set up query in design mode.
2.Put "1" 0r "=1" in Criterion for Cancelled (Boolean) field.
3.Run Query.
Actual Results:
I got the error message listed above.
Expected Results:
I expected the query to run and give me a list of cancelled items.
It does this in the Ubuntu version.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 8; OS: Windows 6.3; UI render: default;
Locale: en-CA (en_CA); Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs