After an update of LO (I think it was the one where the update from HSQLDB to the Firebird was available), the external forms are not working correctly. I changed to Firebird and everything is fine except from the external forms. When I use the forms in the base file itself, they are working fine, but when I create an external form, the changes are not saved (the database is registered, the form is saved as .odt and so on). After opening the external form, the data from the database is shown and I can also add new records and change the existing ones, but at the end nothing gets saved in the main database. When I close the external form and reopen it (or open the main database file), all the changes I made in the external form are gone.
Before that update, the external forms used to work correctly. I was hoping that next updates would fix the issue, but it’s still there. Could it be because I switched to Firebird?
Is there some kind of a new setting that I’m missing when creating an external form?
The database is pretty simple (and made with graphs - I’m not a coder).
Arrgh - it appears to be the Firebird sdbc causing the problem.
Opening an issue on this.
I can give you a quick fix, would require a very simple macro (I think) that would force the commit to happen when using the external form. It would be a short term fix until the main program is updated. I’ll post that back here later this morning, after I write out what I think would work and test it.
Thank you for your quick reply. Please keep in mind, however, that I would probably need a step-by-step guide to apply this quick fix - I’ve never used macros or any other advanced stuff before… It would be nice to have this fixed in one of the future updates :).
No problem, it will be copy/paste simple (I hope). LOL hey, trust me 
Uhm, any news on the topic?