To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113554 Issue #|113554 Summary|Base crashes after SQL insert error from a subform whe |n using button actions to navigate through parent form | records Component|Database access Version|OOO320m18 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab
------- Additional comments from [email protected] Sat Jul 31 01:00:05 +0000 2010 ------- In a Base form with a subform, I have added buttons to trigger the next record / previous record functions. These aren't custom macros, just the default "action" options in the button control's properties. The subform has some required fields (i.e., with non-null constraints on the database table). If you try to navigate away from a half-completed subform, therefore, you sometimes get SQL insert errors. When using the main form's buttons to do the navigation, OpenOffice OFTEN BUT NOT ALWAYS crashes a few moments after you have clicked "OK" to the error warning. In the cases where the button method doesn't crash, the subform data is lost and the main record is still changed. I haven't figured out any differences between when it crashes and when it doesn't. It doesn't crash if you use buttons associated with the subform -- instead, the form goes straight to the "problem" field on the subform, cancelling the navigation request. This feature also happens you try to transfer focus from the subform to any non-button features of the main form. I have re-created the problem in a much simpler sample database, which I will attach in a moment. --------------------------------------------------------------------- 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]
