To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=112014
User atjensen changed the following:
What |Old value |New value
================================================================================
Summary|Saving of base-files with |Updates to embedded databa
|Linux is behaving strange |se not written to file und
| |er certain conditions
--------------------------------------------------------------------------------
------- Additional comments from atjen...@openoffice.org Sun Jun 6 17:50:18
+0000 2010 -------
To reproduce:
Use a BASIC macro to connect to this registered datasource. (DO NOT open the
actual file, just create a connecton)
Update any data.
Close the connection
end the OO.o session.
If no embedded object from the file, or the ODB file, was never opened to the
desktop - then all the changes are lost.
If any GUI object, embedded in the ODB file is opened during the session the
data will be written to the file - even if the updates happened in a macro that
was not called by, or calls, the embedded GUI objects.
For example:
Download the attached file: no-gui.odb
Use the options dialog register the file as no-gui
copy this macro to a library and run it. (remember never actually open the odb
file)
sub test
oContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
db = oContext.getByName("no-gui")
oConn = db.GetConnection ("","")
stmt = oConn.createStatement
stmt.execute( "INSERT INTO ""tblt"" (ID, VAL) VALUES (2, 'sometext')")
end sub
Exit OO.o
Restart OO.o and look at the table in the database, the insert was never written
to disk -
If you did this again, but after running the macro then opening the ODB file.
The data will be written to disk when OO.o session ends, even though via the GUI
the file was never written to disk...
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
