Problems with Open-Source Downloads read https://www.qt.io/blog/problem-with-open-source-downloads and https://forum.qt.io/post/638946
zeroptr last edited by
I have form with tableview its model is a QSqlTableModel... User inserts a record with insertrows.. After inserting user can leave some fields blank .. When he/she changes the row model inserts the data to database.. I want to prevent inserting wrong or blank data to database beforeupdate how can I do this?
Please be more examplish when explaning I'm a new bie..
bsomervi last edited by bsomervi
That should already be taken care of by the model. See
http://doc.qt.io/qt-5/qsqltablemodel.html#setEditStrategy. If you
OnManualSubmityou can choose when to save the new row to the database.
mawh1960 last edited by
Would enforcing rules in your database using triggers not help you here?
If you want to enforce your business rules in the model, you could subclass QSqlTableModel and re-implement the submit() method.
Or, change the model's EditStrategy to OnManualSubmit, create a 'Save' button and check the validity of the data in the button handler before calling the model's submitAll() method.