To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110555 Issue #|110555 Summary|Checkbox action broken Component|Database access Version|OOO320m12 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|tony_52
------- Additional comments from tony...@openoffice.org Thu Apr 1 21:53:51 +0000 2010 ------- I have a checkbox in a Mainform_Grid Previously, in OO 3.1 The following macro is assigned ot the Item Status Change property Sub set_rec_slct(oEvent) DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext") DataSource = DatabaseContext.getByName("aircraft_log_database") Connection = DataSource.GetConnection("","") Statement = Connection.createStatement() oForm = oEvent.Source.Model.Parent oForm = thisComponent.drawpage.forms.getbyname( "MainForm" ) slct_rec_val=oForm.MainForm_Grid.SLCT_REC.currentvalue ph_id=oForm.MainForm_Grid.PH_ID.text supd_slctrec_sql = "update mylglogs.phcomp_log set slct_rec = " & slct_rec_val & _ " where PH_ID = " & ph_id Statement.executeUpdate(supd_slctrec_sql) End sub However when invoked I now get the following error 'illegal object given' The line causing the error is oForm = oEvent.Source.Model.Parent Is there a fix or workaround for this, as I make extensive use of checkboxes, and this is a show stopper. Cheers Tony --------------------------------------------------------------------- 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 --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org