<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Data Records Not Saved to External Firebird Database File" href="https://bugs.documentfoundation.org/show_bug.cgi?id=106463#c17">Comment # 17</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Data Records Not Saved to External Firebird Database File" href="https://bugs.documentfoundation.org/show_bug.cgi?id=106463">bug 106463</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>(In reply to Drew Jensen from <a href="show_bug.cgi?id=106463#c16">comment #16</a>) > (In reply to Robert Großkopf from <a href="show_bug.cgi?id=106463#c15">comment #15</a>) > > *** <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED DUPLICATE - EDITING: Saving data into FB3.0 file impossible when only writing data into a table" href="show_bug.cgi?id=122967">Bug 122967</a> has been marked as a duplicate of this bug. *** > > So - as a work around (scripting vs core code fix) for this there are three > approaches that I see as fairly straightforward. > > 3 - catch the file save event for individual ODB files by updating the > properties of the physical files and issue the commit. (easiest script to > write and it works) > > Maybe this merits a post on the ask.lo service with example script for those. So just to run it by folks - here is the simplest single line macro I could come up with: First add a library to the ODB, if you don't already have one, and add this sub procedure. Sub comitWhenSave() thisdatabasedocument.datasource.getconnection("","").commit() End Sub Then open the Customize dialog and assign that macro to the Save Document Event for the ODB file. That's it, data will be written to disk whenever you do a File Save. (but not a File Save-As ;)</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>