Ask Your Question

Base - external forms not saving data in records

asked 2019-04-19 11:42:12 +0200

Gruby gravatar image

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).

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-04-19 12:21:14 +0200

DrewJensen gravatar image

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.

edit flag offensive delete link more


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 :).

Gruby gravatar imageGruby ( 2019-04-19 12:31:12 +0200 )edit

No problem, it will be copy/paste simple (I hope). LOL hey, trust me ;-)

DrewJensen gravatar imageDrewJensen ( 2019-04-19 12:35:41 +0200 )edit

Uhm, any news on the topic? ;)

Gruby gravatar imageGruby ( 2019-06-06 15:45:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-19 11:42:12 +0200

Seen: 148 times

Last updated: Apr 19 '19