void MainWindow::insert()
{
model->setTable("words_tbl");
while (model->canFetchMore()){
model->fetchMore();}
model->select();
//model->removeColumn(0); // don't show the ID
model->setHeaderData(1, Qt::Horizontal, tr("Deutsch"));
model->setHeaderData(2, Qt::Horizontal, tr("Portuguiesisch"));
ui.tableView->setModel(model);
ui.tableView->setColumnHidden(0, true);
ui.tableView->sortByColumn(1);
ui.tableView->show();
if ((ui.l1_le->text() == "")||(ui.l2_le->text() == ""))
{
QMessageBox::information(this,
"LernIT",
"Please fill field Deutsch and Portuguiesisch");
return;}
if (ui.switch_cb->currentIndex() == 0)
{
/*
QSqlQuery insert;
insert.prepare("insert into words_tbl (language1, language2, plural, description) values ( :lang1, :lang2, :plural, :desc );" );
insert.bindValue( ":lang1", ui.l1_le->text() );
insert.bindValue( ":lang2", ui.l2_le->text() );
insert.bindValue( ":plural", ui.plural_le->text() );
insert.bindValue( ":desc", ui.description_le->text() );
if( ! insert.exec() ) {
QMessageBox::information(this,"LernIT",insert.lastError().text());
ui.l1_le->setText("");
ui.l2_le->setText("");
ui.plural_le->setText("");
ui.description_le->setText("");
ui.l1_le->setFocus();
return;}
*/
rec.setValue("language1", ui.l1_le->text());
rec.setValue("language2", ui.l2_le->text());
rec.setValue("plural", ui.plural_le->text());
rec.setValue("description", ui.description_le->text());
model->insertRecord(-1, rec);
.
.
.
void MainWindow::insert()
{
QSqlTableModel *model = new QSqlTableModel;
model->setTable("words_tbl");
while (model->canFetchMore()){
model->fetchMore();}
model->setEditStrategy(QSqlTableModel::OnFieldChange);
model->select();
//model->removeColumn(0); // don't show the ID
model->setHeaderData(1, Qt::Horizontal, tr("Deutsch"));
model->setHeaderData(2, Qt::Horizontal, tr("Portuguiesisch"));
ui.tableView->setModel(model);
ui.tableView->setColumnHidden(0, true);
ui.tableView->sortByColumn(1);
ui.tableView->show();
if ((ui.l1_le->text() == "")||(ui.l2_le->text() == ""))
{
QMessageBox::information(this,"LernIT","Please fill field Deutsch and Portuguiesisch");
return;}
if (ui.switch_cb->currentIndex() == 0)
{
/*
QSqlQuery insert;
insert.prepare("insert into words_tbl (language1, language2, plural, description) values ( :lang1, :lang2, :plural, :desc );" );
insert.bindValue( ":lang1", ui.l1_le->text() );
insert.bindValue( ":lang2", ui.l2_le->text() );
insert.bindValue( ":plural", ui.plural_le->text() );
insert.bindValue( ":desc", ui.description_le->text() );
if( ! insert.exec() ) {
QMessageBox::information(this,"LernIT",insert.lastError().text());
ui.l1_le->setText("");
ui.l2_le->setText("");
ui.plural_le->setText("");
ui.description_le->setText("");
ui.l1_le->setFocus();
return;}
*/
QSqlRecord rec = model->record();
rec.setValue("language1", ui.l1_le->text());
rec.setValue("language2", ui.l2_le->text());
rec.setValue("plural", ui.plural_le->text());
rec.setValue("description", ui.description_le->text());
model->insertRecord(-1, rec);
.
.
.
To copy to clipboard, switch view to plain text mode
Bookmarks