Language Bindings

Hi,
you do not need the lines
@
query.first()
codeToParseRecord()
@

simply start with query.exec():

@
query = QSqlQuery("SELECT Blahblah, Blippity, Bloop FROM Floozle ORDER BY Bloop")

if (query.exec()) {
while query.next():
codeToParseRecord()
}
@

It works (an helps :) ), thank uou.

Hi,

Since the symbol is not found you are missing a library in your LIBS line

In the case of a standard use of your computer, you'll probably already have several copies of Qt depending on what application you installed.

While developing the problem doesn't occur if you use e.g. Qt Creator since it modifies the environment as needed for your application to run.

You can try the pyside IRC channel or mailing list :)

Thanks for the response -- I'll have to do some translating to PySideify it but I think that's doable. I'll post back if I'm still confused.

Thanks!

Thanks. It´s works

Hmm, the problem seems to be coming from the removecolumn(0) in line 45. When I comment out this line, the text editing works as expected.

is there a way around this?

Also, I still can't get the spinboxes to send changes to the model/SQL data.

Thanks

Hi,

You should also add which version of Qt you are currently using for that. Did you set the Qt::WA_AcceptTouchEvents flag on your widgets ?

Hope jt helps

Hi,

Search for "Simple Widget Mapper Example" in Qt's documentation. It should give you the basics to start your code the right way.

Hope it helps

Try decorating the slot as follows:

@
...
@QtCore.Slot
def method(self):
print("Signal received")
...
@

Hope this helps ;o)

Hi,

It really all depends on how you are going to use the database. If you are planning to use Qt's Model/View paradigm then using the QtSql module would be the logical choice. However you could also implement your own model using python's sql.

You should start by looking at your requirements. Then if both qualifies, just try each to see which one fits your needs better.

Hope it helps

Hi and welcome to devnet,

The bindings are not provided by the Qt project. You should rather try to contact the libraries authors.

Thanks Dheerendra,

A solution was proposed "here":http://stackoverflow.com/questions/25744109/pyqt-qtableview-header-how-to-add-top-right-small-button-to-hide-show-column-wi/25752676?noredirect=1#comment40275860_25752676.

Many thanks to David Cortesi hwo sent me the following Email:

is there a way to have instead:
self.myQTableModel.setData(
self.myQTableModel.index(primaryKeyIndex, col), value)

QAbstractTableModel is extremely abstract! It offers no relational functions, only index() and parent().

It is up to you to make the table model real by adding code. The documentation says you must implement rowCount, columnCount, and data(), and also setData if you want it to be modifiable.

But you may implement other functions. In your situation I would implement a method pkRow(keyvalue) which returns the row number that corresponds to a given primary key value. Then your statement becomes,

self.myModel.setData( self.myModel.index( self.myModel.pkRow(keyvalue), col ), value_for_col)

To save keystrokes, you could write a pkIndex(keyvalue, col) method (built on top of pkRow). Then:

self.myModel.setData( self.myModel.pkIndex(keyvalue,col), value_for_col)

You pkRow method could perhaps cache the recent keyvalues it has seen, to save time.

Note there is also a class QSqlRelationalTableModel, but it does not have any key-dependent methods either. But if your real data is simple SQL table perhaps you should use that.

Hi and welcome to devnet,

Best thing to do is ask the PySide developers on their making-list, you'll probably get a quicker answer there