[PyQt] QComboBox: display text but pass on Unique Id (MySql)

[Cristobal Infante]

I havent found the soultion for this yet, it's driving me a bit mad

can somebody please answer me this "simple" question:

How do you retrieve a single value from a model if you know the index?

Thanks, Cris


On 8 November 2011 22:38, David Boddie <david at boddie.org.uk> wrote:

> On Fri, 4 Nov 2011 13:51:45 +0000, Cristobal Infante wrote:
>
> > My first post in this list, a big hello to everyone :D
>
> Welcome!
>
> > I am just starting with Pyqt but have enough experience with python.
> >
> > I am connecting a Mysql Databse nicely, being able to retrieve the
> complete
> > table and
> > get it as a model. I've then been able to display in a combobox a "Name"
> > column
> > just by using 'setcolumn(1).
>
> OK. So far so good.
>
> > Until here is all good, but is passing the Id from that record that's
> > proven hard to crack for me.
> > I've been looking around in the net, but havent been able to find an
> > example using a database.
> > So display "Jane" put pass on the unique ID of that record.
>
> Just an idea: is the record() method of the model what you want? The model
> should inherit this from QSqlQueryModel.record().
>
> > I have an 'activated' function that is being executed everytime the combo
> > changes, but at the moment it's only retrieving
> > info from that column that's displayed in the combobox.
>
> You can get the corresponding row of the item displayed in the combo box
> by calling the QComboBox.currentIndex() method. This is effectively the
> same as the row in the model, anyway. Then pass it to the model's record()
> method and see what you get.
>
> Does that work?
>
> David
> _______________________________________________
> PyQt mailing list    PyQt at riverbankcomputing.com
> http://www.riverbankcomputing.com/mailman/listinfo/pyqt
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.riverbankcomputing.com/pipermail/pyqt/attachments/20111116/bf654fa4/attachment.html>