Re: Error Explanation/Referential Integrity Question

On Tue, 2 Oct 2007, [email protected] wrote:

> Not sure, but I use wxPython using WAX and if I am looking for the value
> of a combo box, I do something like self.vname.GetValue() which returns
> the text in the combobox. Is that what you are looking for? Or am I
> completely misunderstanding the problem.

Greg,

   Unfortunately, I think you mis-read my problem statement.

   Getting the value of the textCtrl portion of the combo box is accomplished
using self.vname.GetValue().

   My problem is understanding the error message produced by pysqlite2 when I
tried to programmatically delete a specific row in a table. Let me re-show
it:

>   def OnDel(self, event):
>     self.appData.cur.execute ("DELETE from Variable where name = '%s'" %
> self.vname)
>     self.appData.con.commit()

   I've added a warning message box to the code above, but that changes
nothing in the action part.

   ... and python complained

> Traceback (most recent call last):
>   File "/data1/eikos/variablePage.py", line 547, in OnDel
>     self.appData.cur.execute ("DELETE from Variable where name = '%s'" %
> self.vname)
> pysqlite2.dbapi2.OperationalError: near "wxComboBox": syntax error

   I don't know what the syntax error is, which "wxComboBox" is referenced,
nor how "near" the error is. BTW, 'name' is the attribute of that column in
the table.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |         Accelerators(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863