https://bugs.documentfoundation.org/show_bug.cgi?id=166329
Bug ID: 166329
Summary: Creating a user entry variable in a query results in
an error. This worked on HSQLDB but fails after having
converted to firebird embedded
Product: LibreOffice
Version: 25.2.2.2 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
When using a user entry field for a filter criteria results in a failure (i.e
using :InputField). Th parameter entry box is displayed, but then fails with
the following:
The data content could not be loaded
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -206
*Column unknown
*INPUTFIELD
*At line 1, column 944
caused by
'isc_dsql_prepare'
This worked when the database was HSQLDB but now fails after converting to
firebird embedded.
Filter works when entering text in the criterion field
Steps to Reproduce:
1. entering a user input (i.e. :InputField) in the "Criterion" field on the
query consistency produces the above error
2.
3.
Actual Results:
error as above
Expected Results:
query should execute as documented
Reproducible: Always
User Profile Reset: Yes
Additional Info:
None, failure as described above
Version: 25.2.2.2 (AARCH64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 8; OS: macOS 15.5; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.