Issue 26944 - Database form should not save database table contents in form file
Summary: Database form should not save database table contents in form file
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-03-24 19:18 UTC by danstrome
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description danstrome 2004-03-24 19:18:52 UTC 
For a database form and a JDBC datasource with "password required",
the password dialog pops up when the form is first opened,
but the first record in the form is already exposed. 
It remains exposed if the password dialog is cancelled or simply moved aside.

The form should refuse to show any data without a password.

Unzipping the form file and inspecting content.xml shows
that the database data of the current record were saved inside
the form file.  

<form:control 
  <form:text 
      form:current-value="some text data"

And not only the data of the current record.
The entire list from a combo-box was also saved in the file.
This list is supposed to be read from another database table
at the time the form is opened.  It can also be refreshed.
But it should not be saved.
Comment 1 Frank Schönheit 2004-03-25 08:44:15 UTC 
confirming and grabbing
Comment 2 Frank Schönheit 2004-03-25 08:44:59 UTC 
accepting and targeting. Since this is a potential privacy issue, this should be
2.0 at least.
Comment 3 Frank Schönheit 2004-05-17 13:08:20 UTC 
Fixed. Now the following holds:
- for any control which can be bound to a database field:
  - If the control is currently (at the moment the document is saved) properly
bound,
    the current-value will not be written
  - If the control is bound to a spreadsheet cell, or any other external value
supplier
    (e.g. a node in an DOM tree, in the upcoming eForms application), then the
    current-value will not be written
  - In all other cases, the current-value will be written
- for list boxes and combo boxes:
  - If the list entries are obtained from a spreadsheet cell range, they're not
saved
  - If the list entries are obtained from a database table/query/statement,
they're not
    saved
  - In all other cases, the list entries will be written
Comment 4 Frank Schönheit 2004-06-18 16:57:30 UTC 
reopening for reassign to QA
Comment 5 Frank Schönheit 2004-06-18 17:00:19 UTC 
fs->msc: please verify in CWS dba13
(http://eis.services.openoffice.org/EIS2/servlet/cws.ShowCWS?Id=1349&Path=SRC680%2Fdba13)
Comment 6 Frank Schönheit 2004-06-18 17:06:30 UTC 
argh. The CWS is dba12, not dba13. Sorry.
Comment 7 marc.neumann 2004-06-22 08:52:24 UTC 
fixed in cws dba12
Comment 8 marc.neumann 2004-06-22 08:52:49 UTC 
verified in cws dba12
Comment 9 marc.neumann 2004-09-10 10:57:42 UTC 
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc