QSqlTableModel problem with set data

Xardas

db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("test.db");
db.open();
QSqlQuery q(db);
q.prepare("CREATE TABLE IF NOT EXISTS test(id INTEGER PRIMARY KEY AUTOINCREMENT, Date_O VARCHAR(255));");
q.exec();
model = new QSqlTableModel(this, db);
model->setTable("test");
model->setEditStrategy(QSqlTableModel::OnFieldChange);
model->select();
ui.tableView->setModel(model);
connect(ui.add_b, &QPushButton::clicked, [&](){model->insertRow(0); });

After few clicks on button inserted only one row
++ after edit fields data is not stored in table.
What could be the problem?

Thanks in advance!

SGaist

Hi,

For newly added row, OnFieldChange behaves like OnRowChange. See more information here.

Xardas

@SGaist thanks for reply,
but, how i can insertRow row with AUTOINCREMENT ?
example, insertRow() -> insert empty row with AUTO INCREMENT ID.
is it possible without reimplementation?

SGaist

Either trigger the submit yourself or fill all fields in the row.