https://bugs.documentfoundation.org/show_bug.cgi?id=105767
Bug ID: 105767
Summary: Prepared SQL INSERT statement inserts blank rows
Product: LibreOffice
Version: 5.1.4.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 130915
--> https://bugs.documentfoundation.org/attachment.cgi?id=130915&action=edit
Spreadsheet with Basic macros as link between DDE source and biblio.dbf
With StarBasic in OpenOffice I can prepare a statement like this ...
INSERT INTO "Table" ("A","B","C") VALUES (?,?,?)
... and it works with HSQL and dBase at least.
With StarBasic in LibreOffice I can do the same without errors but it does
strange things to my dBase table. The new rows appear blank and they appear on
top of the table grid.
I attach 2 spreadsheets from a little project of mine. One spreadsheet serves
as DDE source, the other one catches the DDE and stores it to a database.
I've prepared it to use the built-in Bibliography which is stored in a dBase
table.
1) Make a BACKUP of your <profile>/user/database/biblio/biblio.dbf. It will be
harmed.
2) Save the 2 spreadsheets in the same directory with macros enabled.
3) Open them both. An auto-open macro will adjust the DDE Topic in cell B3.
3a) My own issue: menu:Edit>Links... break all links and do a hard
recalculation [Ctrl+Shif+F9 or reload]. Now the link should be established.
4) Activate Biblio_LO_Issue.ods, click the start button on the custom tool bar,
confirm the start message, activate the source document and hit F9 to send new
DDE data.
5) Wait some 3 seconds for data arrive in Biblio_LO_Issue.ods and hit F9 again.
The incoming data should be inserted into your biblio table.
6) Activate the Biblio_LO_Issue and hit the stop button.
7) Open the biblio table in the Bibliography data source.
I see blank rows on top of the table which did not exist before and which are
difficult to delete. Same problem with a dedicated dBase table. I just mis-used
your biblio because it is already there. Restore it from backup after this
session.
The exact same setup with AOO inserts data into the first 5 text fiedls of
bilio.dbf.
The exact same setup with LibreOffice HSQLDB (embedded and stand-alone) inserts
correct data.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
