[dba-issues] [Issue 113213] Inopportune renumerotatio n of the key
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113213 User r4zoli changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from r4z...@openoffice.org Thu Jul 22 07:38:25 + 2010 --- Your interpretation of ID in database is different from my. ID is not a number connected to any meaningful way to data stored in other fields of record. It is only a differentiator between records, and keep table tidy. When you delete it and revoke the deletion, the records other data inserted back to database with other ID. What you think is right, that is true in other part of OOo, but not in database table. - 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
[dba-issues] [Issue 113213] Inopportune renumerotatio n of the key
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113213 User r4zoli changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from r4z...@openoffice.org Thu Jul 22 07:38:57 + 2010 --- works for me - closing - 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
[dba-issues] [Issue 113213] Inopportune renumerotatio n of the key
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113213 User r4zoli changed the following: What|Old value |New value CC|''|'r4zoli' Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Resolution| |WORKSFORME --- Additional comments from r4z...@openoffice.org Wed Jul 21 11:51:27 + 2010 --- This is working as desired. When you delete record, the values deleted from database table, and when you ignored deletion the value inserted back to table with next free ID. The database engine with auto-increment fields work as in all database, the integer ID keeps different records, but deleted ID-s not used again. When you use same tables in relations, then database works as you set in relations designer in Update and delete options. - 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
[dba-issues] [Issue 113213] Inopportune renumerotatio n of the key
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113213 User mechtilde changed the following: What|Old value |New value CC|'r4zoli' |'fma,mechtilde,r4zoli' Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Wed Jul 21 12:05:54 + 2010 --- worksforme - closed Only a closed issue is a good issue :-) - 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
[dba-issues] [Issue 113213] Inopportune renumerotatio n of the key
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113213 User py_samyn changed the following: What|Old value |New value Status|CLOSED|UNCONFIRMED Resolution|WORKSFORME| --- Additional comments from py_sa...@openoffice.org Thu Jul 22 05:34:46 + 2010 --- I do not agree on 2 important points: 1) The evoked problem does not occurs during the deletion of a record but during the deletion of the value of the field ID. It is about a bad manipulation of the user which hopes it can cancel it, not of a will to delete a record. 2) The message suggests not saving is possible. In fact no. Thank you - 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
[dba-issues] [Issue 113213] Inopportune renumerotatio n of the key
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 + 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
[dba-issues] [Issue 113213] Inopportune renumerotatio n of the key
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113213 --- Additional comments from py_sa...@openoffice.org Sat Jul 17 16:52:51 + 2010 --- Created an attachment (id=70675) step by step screenshots - 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
[dba-issues] [Issue 113213] Inopportune renumerotatio n of the key
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113213 --- Additional comments from py_sa...@openoffice.org Sat Jul 17 16:53:21 + 2010 --- Created an attachment (id=70676) sample database - 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