[Libreoffice-bugs] [Bug 106463] Data Records Not Saved to External Firebird Database File

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #17 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Drew Jensen from comment #16)
> (In reply to Robert Großkopf from comment #15)
> > *** Bug 122967 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 ;)

-- 
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/20190126/946d2c98/attachment-0001.html>