To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113213 Issue #|113213 Summary|Inopportune renumerotation of the key Component|Database access Version|OOo 3.2.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|py_samyn
------- Additional comments from py_sa...@openoffice.org Sat Jul 17 16:52:10 +0000 2010 ------- Hello The problem occurs when you try to delete value in a primary key & autovalue field. There is no problem when the suppression generates a conflict of referential integrity (the initial value of the key is restored). Steps to reproduce : - open the table Table2 - select a record and delete value in the ID field - Error message : error updating the current record / current row could be updated - Choose Ok - Close the table - Message : the current record has been changed. Do you want to save the changes ? - Choose No - Close the database (no save) - Reload and open the base The record was recreated with the next value (identity). So, 1) the messages are ok but the record is updated even if you choose not to save the changes. 2) It would seem preferable that the operation is the same as when there is a conflict of integrity (restoration of the key) (step by step and screenshot in the attachment) Best regards --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
