To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55731 Issue #:|55731 Summary:|OOo 2.0rc2 crashes navigating a database form Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|jshanks
------- Additional comments from [EMAIL PROTECTED] Mon Oct 10 08:20:05 -0700 2005 ------- I have just installed 2.0rc2 and went back to testing the database functionality. I had to stop with rc1 because of crashes. With 2.0rc2 I am seeing the following problems all related to database navigation from within a form created with OOo base. If you would like me to file separate issues on each of the following problems, let me know. However, from what I can tell, these appear to be related. 1. Moving from record to record, I have seen two crashes that prompted for automatic document recovery. I will attach the error report. This happens when adding and deleting records and does cause the data loss of the displayed record. 2. Data that is displayed in the form is not the same data as in the raw table. This is especially true with autonumber fields. For instance, I created a two record database, with a Primary ID autonumber field and a text field. I created a form with the form wizard. Five records were added and then the last three were deleted. Three more were added, but the autonumber field in the form always displayed "1" within the form. I closed the form and checked the table. In the table the autonumber field showed the actual data as 1,2,6,7,8 which is what I would expect. I reopened the form and again the autonumber field always showed "1". 3. Deleting the last record in the table is causing problems. In the same test as above, I moved to the last of the five records and pressed the "X" delete button. After responding yes to the question, the record was deleted. I expected to be positioned on record 4, but I was actually positioned to record 3. When I got down to two records and deleted the last record, the form locked. I closed the form and reopened it, and the last record was indeed deleted. 4. Deleting a record in a one record database caused an error to appear. I continued the above test and deleted the only record in the database. An error window popped up that said: Error inserting new record. Function sequence error. Pressing "OK" closed the error and properly displays a blank record. All of these errors occurred using both a MySQL database and an OOo flat database file. Let me know if you need any further information as this is a showstopper for our organization. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
