https://bugs.freedesktop.org/show_bug.cgi?id=56645
--- Comment #2 from Vince Radice <[email protected]> --- I was wrong. The file size as shown in Dolphin is 810 kb. As for an error popup , no, I do not get anything. What shows after I click Yes is the unchanged display from before trying to do the delete. There are 3 tables in the data base. Items, recipes, and Merged. Items and Recipes have unique keys. Merged is the relation ship between Items and Recipes. In Merged, Items and recipes are keys into the other tables. Merged.ID is not a key in a different table. I was also able to come up with more info. Using CALC, I exported all of the data from Merged into a spread sheet. I then found out that there were a lot of records with duplicate ID values. There are about 2,200 records in Merged. The highest value for id was around 1850. I did not actually count the number of duplicate records. I usually leave the data base up and open as I reference is a lot during the day. I have also had problems where LibreOffice crashes. When I restart, I get the Recovery screen where is recovers what I had open. Usually Base and 1 or 2 Calc spreadsheets. Where does Base keep the value to use for ID when I add another record? Is it possible that that value got compromised when Base crashed at some point? Using the data I had extracted to CALC, I was able to recreate the Merged table. I still have the bad table and I will upload it if necessary. I am also looking into changing from HSQL 1.8 to maybe hsql 2.2.9 If I can figure out what the conversion process entails. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
