Issue 105782

Checked with an Embedded HSQLdb database on
Go-OO 3.0.1, 
OO.o 3.1.1, 
DEV300m_59 / Ubuntu 9.0.4

OO.o 3.1.1, 
DEV320m_1 / Win 7

Using a detail form for a single record and setting:

Allow Modifications = Yes
Cycle = Active Record [EN_us]
Filter = 

Automatically forces the user to explicitly commit changes (click on next/prev
record, save, restore or close form w/confirming dialog). Tabbing cycles from
last to first control without a commit. 

Two places where Cycle property does not preclude a quite commit:

With a grid control the Cycle property has no effect as a tab from the last
column always moves to the first column in the next row and this triggers the save.

A form with multiple result sets (Master/Sub Form for instance) will save the
data if a tab moves from one result set to another. (One dataform to another).

Created attachment 65291 [details]
Embedded form Details/Dues_no_add has the Cycle set Active Record

(..)
Automatically forces the user to explicitly commit changes (click on next/prev
record, save, restore or close form w/confirming dialog)
(..)


not in here
no dialog pops up (how should it look like?)
TAB and NAV-icons on NAV-bar will all store/update immidiatly

And sorry, TAB does not move to first column/field in the very but to first in
next record.
 

Martin

@martin - OK, so on your installation if you
download the attached database 
opening the form Details/dues_no_add
Edit a value and use tab repeatedly it does not cycle form the last datacontrol
to the first without saving the data?

If not then let me know which OS and which version of OO.o you are using so that
I can try to setup the same here.

yes, it DOES safe

I tried the form Family-Info
and set cycle to record (germ.: Aktueller Datensatz)

1. TAB cycles within the form works
BUT: I see a difference: 
in my form the last control is a table - in yours it is an ordinary field
yours is cycling correct, in mine not

2.
However, the record is updated
2.a: close window will pop up save/cancel, that is okay
2.b: ESC has no function
2.c: the roll-back-icon works
2.d: NAV-key/icons will store changes without pop-up 

Martin


OO.o 3.1.1 (310m19) on win2k with Java 6-16

> in my form the last control is a table - in yours it is an ordinary field
> yours is cycling correct, in mine not

so this boils down to the case Drew mentioned: when you're in a table control,
then TAB cycles through the records *within* the grid control, and thus silently
commits. Right?

> 2.
> However, the record is updated
> 2.a: close window will pop up save/cancel, that is okay
> 2.b: ESC has no function

Do you mean ESC in the dialog which is raised when you close the window, or do
you mean pressing ESC in the form itself (respectively a control therein)? I
assume the latter, in this case, it'd be a different issue.

> 2.c: the roll-back-icon works
> 2.d: NAV-key/icons will store changes without pop-up 

This again sounds like you're trying to come back to issue 36231 (unless I
misunderstand you), where you request no silent commit at all. Please let's keep
this topic out of *this* issue here.


So, if I understand all of the above right, then the "Cycle = 'Active record'"
property works fine for you, *except* when a table control is involved. Correct?

==>fs

no, it neither works for me nor for you:

1.case:
 it does not work, when last control in form is a table-control

2. case:
it partly works when last control is another control:
a) ESC has no function (no drawback of field-entries when in form)
b) cursor-key have no function (of course they should not have some)
c) click on Navigation-icons saves/changes data without pop-up for confirmation

ESC
when for example the control is a text-field, ESC will not draw back the
entries, even you are still in the field/control. This is an issue.

Martin

> 1.case:
>  it does not work, when last control in form is a table-control

Yes, that's what I said above, right?

> 2. case:
> it partly works when last control is another control:
> a) ESC has no function (no drawback of field-entries when in form)

Okay, you answered my question in some round-about way, but ... Again, this is a
different issue then.
http://qa.openoffice.org/issue_handling/basic_rules.html#one_per_issue explains
why it is important to not mix different problems in the same issue.

> b) cursor-key have no function (of course they should not have some)

Then this works as expected ...

> c) click on Navigation-icons saves/changes data without pop-up for
> confirmation

This, again, is another problem, described in an issue which we both know too
well: issue 36231. It would ease things if you would not insist on mixing
different problems in one issue.

> ESC
> when for example the control is a text-field, ESC will not draw back the
> entries, even you are still in the field/control. This is an issue.

A separate one. See above.

Funstuff
it seems something has changed under the hood from 3.1.1 to 3.2, however, not to
the good:
it looks, that is no more possible to have a table-control in the same form with
the normal-fields/controls:
entering data in text-fields is stored to table but unvisible in form itself -
content there is overwriten with "0", having one field in the table-control
makes it immpossible to set 
-- coding of line
-- enter data +/or set empty fields to content not Null
-- entry forced
etc

looks like well organized confusion - however, actually ooo-base became worthless


Martin

Created attachment 66950 [details]
not intended to be here, the screenprint shows the problem

Reset assigne to the default "issues@openoffice.apache.org".