https://bugs.documentfoundation.org/show_bug.cgi?id=156464
Bug ID: 156464
Summary: FIREBIRD: AutoValue shows 0 for all new Entries in
Query with Alias
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 188549
--> https://bugs.documentfoundation.org/attachment.cgi?id=188549&action=edit
Shows 0-result of autovalue when table is queries with alias.
Open the attached screenshot.
There is a table with AutoValue.
Query with
SELECT * FROM "tbl_Test"
will work as expected.
AutoValue will be shown in query.
Now there is an alias for the table:
SELECT * FROM "tbl_Test" AS "a"
AutoValue won't be refreshed any more. Wrong entry '0' is shown instead.
I'm using this kind of query for correlating queries, which works well with
internal HSQLDB. With FIREBIRD the correlation works, but the connected value
of the AutoValue field for the subform is '0' instead of a real value of the
table.
--
You are receiving this mail because:
You are the assignee for the bug.
