SQLQuery assigning column

[nethanjavier]

Man, from what I've read in that documentation, value is a field from my table. So using this code: itemcode = query.value(0).toInt() is wrong? Can you teach me the right way? I already read many documentations and examples, but man, I still can't get it.

[wysota]

So using this code: itemcode = query.value(0).toInt() is wrong?

If you issue that call before the query is executed then what do you expect to receive in "itemcode"?
Furthermore if you call bindValue() after you execute the query then what do you expect the value of ":itemcode" to be used in the query?
If your query doesn't return any rows then what exactly do you expect your variables to contain?

[nethanjavier]

Man, that's how far I understand in PyQt. Using that code,I'm expecting a value that i could pass to my tableview. As what I have explained before, I want to put the values(itemcode,description,srp and vat) to my tableview if my lineedit will find any value in my items table in my database. By using that bindvalue, I could query to my table or finding a record to my table. If my query doesn't find any record, I want to show and error message. Hope you understand me wysota.