GeezerVison is showing github.com — Add 'x rows affected' part to the Execute Query results · Processoriented/sqlitebrowser@82292c2
File tree
Expand file treeCollapse file tree
Open diff view settings
Expand file treeCollapse file tree
Open diff view settings
Collapse file
Copy file name to clipboardExpand all lines: src/MainWindow.cpp +10-1Lines changed: 10 additions & 1 deletion | Original file line number | Diff line number | Diff line change |
|---|
@@ -826,7 +826,16 @@ void MainWindow::executeQuery() |
826 | 826 | if( !queryPart.trimmed().startsWith("SELECT", Qt::CaseInsensitive) ) |
827 | 827 | { |
828 | 828 | modified = true; |
829 | | - statusMessage = tr("Query executed successfully: %1 (took %2ms)").arg(queryPart.trimmed()).arg(timer.elapsed()); |
| 829 | + |
| 830 | + QString stmtHasChangedDatabase; |
| 831 | + if(queryPart.trimmed().startsWith("INSERT", Qt::CaseInsensitive) || |
| 832 | + queryPart.trimmed().startsWith("UPDATE", Qt::CaseInsensitive) || |
| 833 | + queryPart.trimmed().startsWith("DELETE", Qt::CaseInsensitive)) |
| 834 | + { |
| 835 | + stmtHasChangedDatabase = tr(", %1 rows affected").arg(sqlite3_changes(db._db)); |
| 836 | + } |
| 837 | + |
| 838 | + statusMessage = tr("Query executed successfully: %1 (took %2ms%3)").arg(queryPart.trimmed()).arg(timer.elapsed()).arg(stmtHasChangedDatabase); |
830 | 839 | } |
831 | 840 | break; |
832 | 841 | } |
|