Re: Error Explanation/Referential Integrity Question

 -------------- Original message ----------------------
From: Rich Shepard <[email protected]>
> On Tue, 2 Oct 2007, Adrian Klaver wrote:
> 
> > Is this value assigned to a variable?
> 
> Adrian,
> 
>    Yes: self.vname.
> 
> > Should self.vname be self.vname.GetValue()?
> 
>    Well, duh! Of course! self.vname is a wxPython object, not the string
> associated with that object. Sigh.
> 
> > My guess is, the wxComboBox is the one that the vname value comes from.
> > The syntax error may be that the value being assigned to %s is incorrect.
> 
>    I corrected that error, and there are no more error messages, but the
> deletion does not occur. Now I need to track down why not.

I see that you have self.appData.con.commit() which is usually the step I forget.
Another reason a delete would not occur is that WHERE condition does not match.
Are you sure there is not a formatting problem? i.e. the text control is returning a 
value with padded spaces, whereas the value in the table is not padded.

> 
> Many thanks,
> 
> Rich

--
Adrian Klaver
[email protected]