[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

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|Linux (All)                 |All
                 CC|                            |btomi96 at gmail.com,
                   |                            |iplaw67 at tuta.io,
                   |                            |lionel at mamane.lu

--- Comment #17 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to Stang from comment #16)
> With further testing, can get to FLUSH.  Doing this with the connection,
> just need to add another line in the macro after the SQL executeUpdate and
> before the close() line:
> 
>     Conn.getParent().flush
> 
> Now data is saved to Firebird embedded without it being opened.

@Stang: thanks for your tests !

>From memory, the .getParent call is what binds the form (be it Calc or an
independent Writer form) to the connection context (in the MVC world of UNO),
so this is indeed the issue with the commit failing in normal use, i.e. the
failure to find the parent if the ODB file isn't open simultaneously.

However, if this now works for embedded hsqldb, then it should also work for
Firebird...so perhaps the code that creates an embedded Firebird ODB file fails
to expose that MVC correctly ?

I'm not up to date with the way MVC works in the context of an embedded
Firebird ODB, but really we ought to be striving to obtain the same thing.

@Lionel, Tamas : putting you on copy for thoughts on this?

-- 
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/20191112/abff6409/attachment.html>