setEditStrategy AttributeError: type object 'QSqlTableModel' has no attribute 'OnFieldChange'

PythonQTMarlem

Hello,
There are many examples here in the forum that it works like this:

        filename = os.path.join(os.path.dirname(__file__), "telefonnummern_verwaltung.db")
        db = QSqlDatabase.addDatabase('QSQLITE')
        db.setDatabaseName(filename)
        if db.open():
            self.table_model = QSqlTableModel()
            self.table_model.setTable("telefon_verwaltung")
            self.table_model.setEditStrategy(QSqlTableModel.OnFieldChange)
            self.table_model.select()

But I get this error message:

self.table_model.setEditStrategy(QSqlTableModel.OnFieldChange)
AttributeError: type object 'QSqlTableModel' has no attribute 'OnFieldChange'

What am I doing wrong?

JonB

@PythonQTMarlem
Goodness knows, it looks correct to me, this is Python/PySide.... Can you maybe press F2 key in Creator on QSqlTableModel and it takes you to wherever the PySide class definition is so you can look around to see if OnFieldChange is there?

PythonQTMarlem

@JonB Thank you for your answer.
I don't use the qt-creator. I code qt in PyCharm.

In my imports I have just PyQt6. No PySide.

can I also implement your idea without qt Creator?

SGaist

Hi,

Can you try with QSqlTableModel.EditStrategy.OnFieldChange ?

JonB

@PythonQTMarlem
Well whatever the key is in PyCharm then. To let you browse definitions.
Try @SGaist's suggestion.

PythonQTMarlem

@SGaist Thank you.
Your code doesn't produce an error message.
This code also does not generate an error message:

QSqlTableModel.EditStrategy.OnFieldChange

or this Code:

self.table_model.EditStrategy.OnFieldChange

But when I change a column in a record. I then go to another column in the same data set and then exit the program. Then my change was not saved.

When I change the record, then my change was saved.

PythonQTMarlem

@JonB
Thanks. I just did. Unfortunately didn't quite have the desired result.

JonB

@PythonQTMarlem
Well at least that has resolved the Python issue, thanks to @SGaist's correct guess.

Try with OnManualSubmit and an explicit submitAll() (e.g. from a button, and check its return result). Find out whether it's actually OnFieldSubmit or updating in general which is at issue.

PythonQTMarlem

I have the solution:
self.table_model.setEditStrategy(QSqlTableModel.EditStrategy.OnFieldChange)

look here:
https://www.tutorialspoint.com/pyqt/pyqt_database_handling.htm

Thank you for your help!