SQL result problem

[unix7777]

Thanks.Now it works!It was the wrong column.

[unix7777]

Never deleted using this code:

QModelIndexList selectedList = ui->tableView_clients->selectionModel()->selectedRows();
 
    int selected_row;
    int i=0;
    selected_row=((selectedList.at(i).row())-1);
    QString row=QString::number(selected_row);
 
    QSqlQuery query;
    query.prepare("DELETE from clients where ClientId="+row);
 
    query.exec();

QModelIndexList selectedList = ui->tableView_clients->selectionModel()->selectedRows();

    int selected_row;
    int i=0;
    selected_row=((selectedList.at(i).row())-1);
    QString row=QString::number(selected_row);

    QSqlQuery query;
    query.prepare("DELETE from clients where ClientId="+row);

    query.exec();

To copy to clipboard, switch view to plain text mode 

[Lesiok]

Try this :

QModelIndexList selectedList = ui->tableView_clients->selectionModel()->selectedRows();
 
    int selected_row;
    int i=0;
    selected_row=((selectedList.at(i).row())-1);
    QString row=QString::number(selected_row);
 
    QSqlQuery query;
    QString my_query = QString("DELETE from clients where ClientId=")+row;
    query.prepare(my_query);
 
    query.exec();

QModelIndexList selectedList = ui->tableView_clients->selectionModel()->selectedRows();

    int selected_row;
    int i=0;
    selected_row=((selectedList.at(i).row())-1);
    QString row=QString::number(selected_row);

    QSqlQuery query;
    QString my_query = QString("DELETE from clients where ClientId=")+row;
    query.prepare(my_query);

    query.exec();

To copy to clipboard, switch view to plain text mode 

Look what You get in my_query after line 9 and think why.

[ChrisW67]

... and be aware that the model row number and and the ClientID are not necessarily related to each other in any way.

Why don't you use the model to QAbstractItemModel::removeRow() the selected item?