To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113509 Issue #|113509 Summary|Base file give errors when attempting to update data b |y ANY means, duplicates records, deletes records at ra |ndom when opened with Oo 3.2.1 Component|Database access Version|OOO320m18 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|deskjockey
------- Additional comments from deskjoc...@openoffice.org Thu Jul 29 01:45:42 +0000 2010 ------- I have been using a Base database to track items for three years, and it had been working well until I upgraded to version 3.2.1 on a Vista desktop. As soon as I opened the Base file in 3.2.1 for the first time and tried to add data to it, I started noticing problems. When trying to save a change made to an existing record via a Form drop-down menu, I got the following error message: SQL Status: 37000 Error code: -16 Wrong data type: java.lang.NumberFormatException: For input string: "A-37 Dragonfly cockpit set" I then tried to change random data both manually in a table view and via the input form and got the same error code and SQL status message. I then noticed something strange in the table view--some records were repeated and others had disappeared (each record is assigned a unique ID number, so I first noticed when I saw duplicate ID numbers and missing ones--i.e., instead of "1,2,3,4,5,6" I saw records "1,2,2,4,4,6" with identical information in the duplicate records). Thinking it was a problem with the file itself, I restored a backed-up copy of the database from a few weeks ago (one I knew for a fact was pristine) and opened it. I got the same problems. I then chose a very old back-up copy (seven months old) and tried again--I experienced the same exact problems. Can anyone shed some light on this or provide a work-around? --------------------------------------------------------------------- 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