https://bugs.documentfoundation.org/show_bug.cgi?id=164433
Bug ID: 164433
Summary: FIREBIRD: AutoValue shows 0 when connected to server
with ODBC or JDBC connection
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
For this bug you will need a running Firebird server 3. Should be version '3',
because you could use Firebird files, created with LibreOffice Base, for this
server type.
Connect to the database of the sever by direct connection (Firebird). Here a
simple connection string on OpenSUSE (path for Firebird) and connected to
libretest.fdb:
localhost:/srv/firebird/libretest.fdb
Create a table with autovalue, if it hasn't been created.
Put some data into table.
AutoValue will be created, could be seen directly after input. Also <AutoValue>
appears in a new row.
Driver of LO is only created for one connection to a database field. So you
couldn't connect from another client and open the same table. Using internal
Firebird driver for more than one client won't work.
So we tested ODBC and JDBC.
Opened the table in ODBC and JDBC give the same result:
New values for primary key are all shown as '0'.
Reloading the table shows: All keys are created well, but aren't shown
directly.
<AutoValue> wont be shown in row for new entries.
This bug is a big problem for connecting forms and subforms. Connecting by a
key value of the mainform, created by AutoValue, will try to save the content
of the subform with foreign key '0', which doesn't really exist.
Note:
INSERT INTO "tbl_Test1" ("Name") Values('Robert') RETURNING "ID"
will return a value for "ID", if it will run in macro code. So there is a
possibility to get the value. But at this moment I have to reload the form to
get the right value.
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
