[Libreoffice-bugs] [Bug 128607] Firebird database must be opened at all times in order to insert data using BASIC of Calc.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128607

--- Comment #13 from Stang <sgrekow at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191109/5f7fd492/attachment.html>