https://bugs.documentfoundation.org/show_bug.cgi?id=128607
--- Comment #13 from Stang <sgre...@yahoo.com> ---
There appears to be two problems with the original post. The first is the Calc
file code. In `Sub UpdateSQL_Original` this statement:
Dim TestDate AS Date
should be:
Dim TestDate AS String
This corrects the error seen by @Alex Thurgood.
The second problem is the title of the bug. The database does not need to be
open to process the SQL transactions. The actual problem is with the
registered database never opened, if the Calc file is closed, a Commit is not
issued to the Firebird DB and the data is thus not saved. There also does not
seem to be any method to send a Commit from Calc to accommodate this.
If before closing The Calc file, the Base file is opened and saved (save
indicator is on at this point), the data is saved (committed).
There is no warning anywhere when in Calc that upon closing the database data
needs to be saved.
Confirmed with:
Version: 6.3.3.2
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
--
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
