--- a/db.dataview/src/org/netbeans/modules/db/dataview/output/DataViewTableUI.java +++ a/db.dataview/src/org/netbeans/modules/db/dataview/output/DataViewTableUI.java @@ -377,7 +377,8 @@ int[] rows = getSelectedRows(); String insertSQL = ""; for (int j = 0; j < rows.length; j++) { - Object[] insertRow = dataView.getDataViewPageContext().getCurrentRows().get(rows[j]); + int modelIndex = convertRowIndexToModel(rows[j]); + Object[] insertRow = dataView.getDataViewPageContext().getCurrentRows().get(modelIndex); String sql = dataView.getSQLStatementGenerator().generateRawInsertStatement(insertRow); insertSQL += sql.replaceAll("\n", "").replaceAll("\t", "") + ";\n"; // NOI18N } @@ -401,8 +402,9 @@ int[] rows = getSelectedRows(); String rawDeleteStmt = ""; for (int j = 0; j < rows.length; j++) { + int modelIndex = convertRowIndexToModel(rows[j]); SQLStatementGenerator generator = dataView.getSQLStatementGenerator(); - final String deleteStmt = generator.generateDeleteStatement(rows[j], getModel()); + final String deleteStmt = generator.generateDeleteStatement(modelIndex, getModel()); rawDeleteStmt += deleteStmt + ";\n"; // NOI18N } ShowSQLDialog dialog = new ShowSQLDialog();