MYSQL save changes

[eleanor]

Hi. I'm using MySQL to write/read from the Mysql database.

I'm using QTableView to represent tables on the screen.
The problem is when the table is shown, and if I edit it manually, then I want to save the changes and I don't know how.




The second problem is:

void dbWindow::add_changes_kraj() {
	QSqlQuery query;
	QString table_name = "kraj";
	//we use NULL because this is not php, and it will auto increment on it's own
	query.prepare("INSERT INTO :table (id,ime,postna_st) VALUES(NULL,:ime,:postna_st)");
	query.bindValue(":table",table_name);
	query.bindValue(":ime",edit_ime->text());
	query.bindValue(":postna_st",edit_postna_st->text());
	query.exec();
	//query.exec("insert into kraj values(NULL,'Town','4532')");
	emit close();
}

void dbWindow::add_changes_kraj() {
	QSqlQuery query;
	QString table_name = "kraj";
	//we use NULL because this is not php, and it will auto increment on it's own
	query.prepare("INSERT INTO :table (id,ime,postna_st) VALUES(NULL,:ime,:postna_st)");
	query.bindValue(":table",table_name);
	query.bindValue(":ime",edit_ime->text());
	query.bindValue(":postna_st",edit_postna_st->text());
	query.exec();
	//query.exec("insert into kraj values(NULL,'Town','4532')");
	emit close();
}

To copy to clipboard, switch view to plain text mode 

- what is commented (query.exec("insert into kraj values(NULL,'Postojna','4532')") works perfectly, but the other lines don't (which is the same...and I need to make them work).

Any idea?

[jpn]

What happens if you don't try to bind the table name? Also, QSqlQuery::bindValue() docs seems to suggest binding NULL values like this:

query.prepare("INSERT INTO kraj (id,ime,postna_st) VALUES (:id,:ime,:postna_st)");
query.bindValue(":id",QVariant(QVariant::Int));
query.bindValue(":ime",edit_ime->text());
query.bindValue(":postna_st",edit_postna_st->text());
query.exec();

query.prepare("INSERT INTO kraj (id,ime,postna_st) VALUES (:id,:ime,:postna_st)");
query.bindValue(":id",QVariant(QVariant::Int));
query.bindValue(":ime",edit_ime->text());
query.bindValue(":postna_st",edit_postna_st->text());
query.exec();

To copy to clipboard, switch view to plain text mode 

[eleanor]

It works now. Thank you.

Now I only need a way to store the changed values into mysql table (I'm changing in QTableView).

[jpn]

You have to decide in which way you want your application to behave (see QSqlTableModel::EditStrategy). In case you decide to use QSqlTableModel::OnManualSubmit, you will have to use QSqlTableModel::submitAll() to submit changes. Otherwise changes will get automatically submitted as QSqlTableModel::EditStrategy docs explain.