SQLite make problems

[jacek]

I have insert two new lines, is that correct, because i have same problem:

If you have the same problem as the one discussed on qt-interest, then it means you can't have more than one query object at once.

Try executing that loop before you create QSqlQuery and create only one instance of that class.

[raphaelf]

Hi ..

I am using before insert a new row like that

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);
.
.
.

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 

Should i post my .cpp file?

Please help me

[ad5xj]

I think many of you questions on record and database locking can be answered here:

http://www.sqlite.org/lockingv3.html

[raphaelf]

Hi,

Thanks for the Link..

Should i find the solution there?Or ii dont have a solution for my probllem?