Created attachment 150878 [details]
Test ODB and ODT files
Test platform Ubuntu 18.04 w/ Version: 220.127.116.11
Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Also checked with 6.3Alpha with same results.
1 download the attached zip file, expand the two files and register the supplied ODB file with default name.
2 open the ODT file fb_mig_bigint_extfrm.odt and enter some values in the table grid control.
3 close the file (save it if asked)
4 open the ODB file fb_mig_bigint.odb and open the default form (or table)
Error - the newly entered data from step 2 is lost.
1 open the ODB file first
2 open the ODT file and enter some data in the table grid control
3 toggle back to the ODB and open the table in it.
The newly entered data is displayed in the table, embedded in the ODB.
4 close the ODT file (save if asked)
5 data is still in the ODB table
6 close the ODb file - you will be prompted to save the file. If you don't the new data is lost.
This is what is happening it appears when using the form in the ODT file, the connection to the ODB database is closed without the commit of the data to disc that would of happened when the ODB was written to disc.
checked this with 6.0 also, so moving the version.
now realize, this will likely be same root as issue 117513 so will set this as a dup to that.
Too bad, I was hoping the same basic workaround for FIREBIRD File sdbc not writing data would work here, but it doesn't.
*** This bug has been marked as a duplicate of bug 117513 ***
@Drew : isn't this a DUP of bug 112458 instead ?