Re: Error Explanation/Referential Integrity Question

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.

Thanks,

Greg Givler
Information Technology
Lockwood®
10 Valley Stream Parkway
Malvern, PA 19355
Phone: (484) 605-4826
Email: [email protected]



Rich Shepard <[email protected]> 
Sent by: pysqlite-bounces-IAPFreCvJWPBWskQ1e/[email protected]
10/01/2007 02:40 PM
Please respond to
Rich Shepard <[email protected]>; Please respond to
pysqlite list <pysqlite-IAPFreCvJWPBWskQ1e/[email protected]>


To
pysqlite list <pysqlite-IAPFreCvJWPBWskQ1e/[email protected]>
cc

Subject
[pysqlite] Error Explanation/Referential Integrity Question






   I tried deleting a selected record using this syntax:

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

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

   The row I want to delete is the text ctrl portion of the wx.ComboBox, 
not
in the list portion. How do I learn just what the syntax error is on this
operation?

   On the topic of deleting records, I have a hierarchy of related tables 
and
need to implement DELETE triggers for them. My assumption is that each 
table
needs a trigger for the one immediately referenced by it, so I need a
cascade of triggers working down the hierarchy. For example, if table foo
has rows with details for each in table bar, and the rows in table bar 
have
foreign key related rows in table baz, then I need to create a trigger on
foo that checks for rows on bar, a trigger on bar that checks for rows on
baz, then delete the applicable rows working my way up the hierarchy. Is
this correct?

   Regardless, until I figure out what 'wxComboBox' syntax error means, 
I'm
stymied.

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
_______________________________________________
pysqlite mailing list
pysqlite-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/pysqlite

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please call the help desk at ext 4850
______________________________________________________________________


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

_______________________________________________
pysqlite mailing list
pysqlite-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/pysqlite