Apache OpenOffice (AOO) Bugzilla – Issue 15027
too much error messages when copying table rows fails
Last modified: 2006-05-31 14:29:06 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 :)
Created attachment 6500 [details] sample case to reproduce the bug
targeting
Fixed in cws oj5. Best regards, Ocke
change subcomponent to 'none'
.
Marc, could you please verify this one. Thx. Ocke
fixed in CWS oj5
verified in CWS oj5
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