Hide Forgot
Description of problem: While working with openoffice-base a crash was experienced. I created a table, summation query and form based on the table as form and the summation query as a subform. The error occurred when I tried to enter new data into the table via the form. Version-Release number of selected component (if applicable): openoffice.org-base-2.0.3-7.4 How reproducible: Create database with one table, one query to add up sums and a form with the table as the main form and the sum query as the subform. Steps to Reproduce: 1.create database 2.add new record to table via the created form 3.see OOo crash, include with bug report Actual results: Crashed and brought up window with error related information to add to report Expected results: Being able to add a new record to the database via created form. Additional info: I have created a lot of databases using Access since 1997 and note that openoffice-base is fairly primitive. I am glad though that there is an alternative database where a user can create personal databases for usage in a simple manner. Major features lacking are no ability or obvious way to format query results to display in currency, percentage and other aspects. Attached is the dumped file pasted into gedit.
Created attachment 132117 [details] messages openoffice seems are helpful
After recovering from the crash, the query was gone, the form was gone. Also, the cell formatting for currency, percentage and date were all missing. I experienced another crash under different circumstances. I added conditions for the subform to link to the main form. SQL werrors experienced with this problem.
Created attachment 132119 [details] added link from master form to subform errors when loading form. Second crash of forms
Created attachment 132121 [details] what is being created This is an odt file to show the form and subform created
Can you give me a step by step process to get your crash ?
Table: create table with several field in them. ID and institute as text. Create fields as type real number. Create filters for real number fields as currency and one as percentage. Query: create query for balance and monthly payments as SUM function. Form: Use wizard to create form based on table (select all fields for form) and add a subform by selecting the query. (select all fields for form.) Choose columnar labels-left for the main form and columnar labels-left for the subform. Open form and go to last record, try to enter data in the form. The form crashed with the first exception. On the second crash, I chose to link the main form balance to the subform balance summary. I ended up having an additional error followed by the second exception output. When I created the first form as a datasheet and the summary query as columnar labels-left, the form works other than not maintaining the currency and percentage formatting that I desired. If I recall, the columnar labels left form maintained proper cell formatting. Entering data was the drawback.
Can you give this a go for me, setup in oobase the situation before it would crash, and then do a"SHUTDOWN COMPACT" in the Tools/SQL window and attach the saved .odb here.
I tried to recreate the crash with the present development versions and everything is working now. I did try the SHUTDOWN COMPACT as described and had a successful prompt returned. The bug seems to not be present any longer with forms of different views nor losing formatting for currency, date or percentage. The only actions that I took to differentiate the system was to remove stray #prelink# files and allow prelink to complete its run on the system. I like that the crash is gone. I just feel like time was consumed on a bug which seemed to stop happening mysteriously. The database is working with both data form and columnar now. Should I close this bug?
That is very strange, there may have been something that changed in gcj/gcc or perhaps there was something to the prelink stuff. Yeah, feel free to close it if you cannot reproduce anymore, and feel equally free to reopen if it returns
We'll close it for now, and reopen if it returns
If it resurfaces, I will re-open the report. I'm glad that it started working, prelink or improvements to the libraries. I'll take either.