To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=36231
------- Additional comments from [email protected] Sat Oct 10 14:49:37 +0000 2009 ------- ==>fs you wrote: Since all our connections are set to AutoCommit=TRUE, this means that after that statement has been executed, the new data is immediately in the database (modulo some write caches, if you're working with the embedded HSQLDB) (...) This BOTH is what I ment, and for everybody not knowing the story here is the link: http://hsqldb.org/doc/guide/ch09.html#set_autocommit-section so, AutoCommit is an option to the tables, which must-be-used, and can not be left in default state. And, EVEN when using HSQL as a memory-only DBMS, "statements" should not be written to any cache, but need to be executed immidiatly (btw.: I am no friend of memory-only DBMS). I you want to make a ROLL-BACK possible, this needs to be done on base of transaction-protocol, not on base of a "do-nothing-until" ... whatsoever. You asked for a workflow? What do you expect, tricky stuff? I just look at a records and walk record-wise through a table/a view? nothing with marcos etc, just using ordinary functions. so: quote again: (..) dialog at every point where today a silent "commit to database" happens, asking the user for confirmation. (..) yes, of course, this is what we are talking about (note: the smart version of dealing with things like this is, not to do anything and to stay in the TAB-cycle until COMMIT is given, or to pop-up the dialog, when record is changed but shall be left by ESC or NAV-Keys.) (..) There could be other (better?) solutions to this (..) really? which ones? you do not like moaning? Sorry, here you have it again. Since years OOo stumbles over smart features (here: autoCommit), whereas the basics (explicit commit) are missing. Okay, this can happen, system-developement and programming are different jobs, but it should not be a big problem to do the programming, when things are clear. You complain about moaning? I think, things would become much easier, when I charge you for good advice. Martin --------------------------------------------------------------------- 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: [email protected] For additional commands, e-mail: [email protected]
