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 f...@openoffice.org Fri Oct 9 09:39:42 +0000
2009 -------
> 1. You changed the behavior of forms
Huh?
> 2. the method setautocommit is still unused
>
> While there had been a chance to substitute the lack of the missing 2. by
> using a working cycle-function within forms, even that isn't working anymore.
That is exactly what I asked you (above) to elaborate - the cycle function works
perfectly, as far as I know, so I do not remotely know what you refer to here.
> I am sure you knew that
No, I didn't, and still don't know.
Still, I do not understand the work flow you have in mind. Currently, it is as
follows:
1. When you enter data into a control, and leave this control, this data
is transferred ("committed") to the result set row. Still, this happens
"client-side", the result row is not yet updated to the database.
2. When you move to another record, then all modifications to the current
result row are updated ("committed") to the database, effectively executing
an "UPDATE" SQL statement.
2a. 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).
2b. Moving to another record is (by default) also done when you TAB through
your controls. This can be prevented by setting the "Cycle" property of
the form to "Active Record". (This is what you claimed doesn't work
anymore, but I don't see any problem here.)
3. Explicitly pressing the "Save Record" button also updates ("commits") the
data to the database, issuing the very same UPDATE statement.
In which of those steps, the behavior you expect would differ?
---------------------------------------------------------------------
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
