Issue 15027 - too much error messages when copying table rows fails
Summary: too much error messages when copying table rows fails
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-28 16:15 UTC by Frank Schönheit
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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


Attachments
sample case to reproduce the bug (756 bytes, application/zip)
2003-05-28 16:18 UTC, Frank Schönheit
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2003-05-28 16:15:34 UTC
* extract the attachement into an empty folder
* create a new dBase data source, pointing to this folder
* open the data source browser, therein display the bugdoc table
  The table contains a column "text_id", and a unique index for this table
* select one of the two records of this table, drag and drop them into empty
space of the table view
=> this starts copying the records
=> 3 error messages:
   - Duplicate value found in column 'text_id'
   - Function sequence error
   - An error occured. Do you want to continue copying?

(The bug is independent on the concrete database type, I could also reproduce it
with a MySQL database.)

This definately are too much error messages :). I think we have several problems
here, with different severity:
- When copying one record fails, we should only show _one_ message for this: The
  "Function sequence error" message is not only senseless (because it doesn't
  tell the user anything), but it also indicates that the copy process continues
  to do something, though it already failed
- We should not ask the user if s/he wants to continue copying if we are already
  dealing with the last record.

Of course it would be really really cool if the copy process would
* detect that
  - the source and the destination table are the same
  - the table contains a unique index or a primary key
* properly recognize that this means that copying will _definately_ fail, and
  offer the user a set of choices how to handle this, up to allowing the user
  to explicitly specify new values for the key columns for every record to
  be copied. But this probably is a topic for a separate issue :)
Comment 1 Frank Schönheit 2003-05-28 16:18:12 UTC
Created attachment 6500 [details]
sample case to reproduce the bug
Comment 2 Frank Schönheit 2003-05-28 16:18:43 UTC
targeting
Comment 3 ocke.janssen 2003-07-09 13:19:29 UTC
Fixed in cws oj5. 

Best regards,

Ocke
Comment 4 hans_werner67 2004-02-02 12:14:47 UTC
change subcomponent to 'none'
Comment 5 ocke.janssen 2004-05-24 10:01:24 UTC
.
Comment 6 ocke.janssen 2004-05-24 10:02:19 UTC
Marc,

could you please verify this one. Thx.

Ocke
Comment 7 marc.neumann 2004-05-26 13:33:09 UTC
fixed in CWS oj5
Comment 8 marc.neumann 2004-05-26 13:33:26 UTC
verified in CWS oj5
Comment 9 marc.neumann 2005-01-05 10:49:57 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