<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Firebird database must be opened at all times in order to insert data using BASIC of Calc." href="https://bugs.documentfoundation.org/show_bug.cgi?id=128607#c13">Comment # 13</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Firebird database must be opened at all times in order to insert data using BASIC of Calc." href="https://bugs.documentfoundation.org/show_bug.cgi?id=128607">bug 128607</a> from <a class="email" href="mailto:sgrekow@yahoo.com" title="Stang <sgrekow@yahoo.com>"> Stang</a> <pre>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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>