Issue 7595

Summary:

[dBase]Form / subform controls not saved -- lost on reopening

Product:

Base

Reporter:

danstrome <dan.strome>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

ACCEPTED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.0.1

Keywords:

needhelp, oooqa

Target Milestone:

---

Hardware:

OS:

Windows 98

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
dBase tables, forms, and description for lost form controls - (zipped size = 76K)	none
Daniel's readme as extracted from his attachement	none
readme for dBase table linking experiments - part 2	none
zip of dBase tables and forms - part 2 (size = 70K)	none
readme for doctors-procedures forms with combo boxes	none
zip of doctors-procedures forms and mysql tables	none

Description danstrome 2002-09-09 02:13:57 UTC

When making a form and subform (Autopilot > Form)
to link two dBase tables together, 
most of the graphical controls are lost 
when the form is saved, closed, and reopened.
Happened in about half of experiments.

The Form Navigator thinks all the parts are still present,
but most controls are not visible.
This may be a UI issue.

This issue is a response to the dev@dba mail message
http://dba.openoffice.org/servlets/ReadMsg?msgId=398440&listName=dev

The response was too long, so I zipped everything up
and attached it to this issue.

See attached zip file containing dBase tables, forms,
two content.xml files, and 
a writer document explaining the procedure and results
and comparing the content.xml files.

Unzip the files into some directory and create
a data source called  exper_dbase_linked
that points to the  exper_dbase  directory
to make things work.

Comment 1 danstrome 2002-09-09 02:17:36 UTC

Created attachment 2770 [details]
dBase tables, forms, and description for lost form controls - (zipped size = 76K)

Comment 2 Frank Schönheit 2002-09-09 07:48:50 UTC

Created attachment 2774 [details]
Daniel's readme as extracted from his attachement

Comment 3 Frank Schönheit 2002-09-09 08:16:59 UTC

Daniel, thanks for the extensive explanations. I had a look into some
of the documents, and they were definately broken (in a way which
cannot easily be repaired during loading).

Sadly, I have the small problem that I could not reproduce "Experiment
1" - I followed your instructions step-by-step, and everything was
fine (in OpenOffice.org 1.0 as well as 1.0.1). I did not yet try the
other scenarios (Marc, can you reproduce some of them?).

Dealing with 1., it would be interesting if we can break this down.
For instance:
* does the same broken document appear if you only create the form
with the auto pilot, and immediately reload it (without modifying)?
* does the same broken document appear if you do only create the form,
without creating the tables from scratch?

BTW: The one effect you described (improper linking after creating the
sub form with the grid) is because you entered "elemen01.elem_id" as
"link master fields". You only need "elem_id", this is automatically
set in the context of the parent form. After this, the linking works.

Comment 4 Frank Schönheit 2002-09-09 08:18:39 UTC

Daniel, another question: From the broken document, I supect the auto
pilot is doing something wrong. Did you, on the second page, really
only select the first button, or did you click around a little bit
before, trying different layouts or such?

Comment 5 danstrome 2002-09-16 20:41:16 UTC

I should have left #1 out.
It is the most complicated example,
and I played around with a lot of settings.
The other examples are simpler.

Thanks for the hint about not needing to use
table_name.column_name in the SQL statement.
I had just been assuming it was needed.
But I now see it works quite well without the table_name.

I am uploading two more zipped files of examples,
in which graphical control widgets disappeared
during saving and reopening.
Each has a separate readme.

The first is more dBase table linking experiments,
tried with and without the AutoPilot.

The second is an example of using combo boxes
to display the items in lookup (reference) tables,
using 3 MySQL tables.

Comment 6 danstrome 2002-09-16 20:44:06 UTC

Created attachment 2858 [details]
readme for dBase table linking experiments - part 2

Comment 7 danstrome 2002-09-16 20:59:19 UTC

Created attachment 2859 [details]
zip of dBase tables and forms - part 2   (size = 70K)

Comment 8 danstrome 2002-09-16 21:06:25 UTC

Created attachment 2860 [details]
readme for doctors-procedures forms with combo boxes

Comment 9 danstrome 2002-09-16 21:08:30 UTC

Created attachment 2861 [details]
zip of doctors-procedures forms and mysql tables

Comment 10 marc.neumann 2002-10-11 11:47:20 UTC

set the status to started

Comment 11 marc.neumann 2003-02-18 10:02:05 UTC

set target

Comment 12 hans_werner67 2004-02-02 12:33:03 UTC

change subcomponent to 'none'

Comment 13 thorsten.ziehm 2004-08-19 15:46:45 UTC

Because of limited resource for OOo2.0, it was decided to shift this tasks to
the next milestone. If somebody will be found, who can implement this until
OOo2.0, then this tasks will be re-targeted.