# HG changeset patch
# User Matthias Bläsing <matthias42@netbeans.org>
# Date 1330183004 -3600
# Branch dbfixes
# Node ID 6a216333800c1eef3afbdb0a46124fc3f9cc703b
# Parent  5139ba7556508b72ec767c8fe7c4f3c41ad541a2
"show script for insert" and "show script for delete" need view-model-conversions to get the correct row (as suggest of the author in bug #206470)

diff --git a/db.dataview/src/org/netbeans/modules/db/dataview/output/DataViewTableUI.java b/db.dataview/src/org/netbeans/modules/db/dataview/output/DataViewTableUI.java
--- a/db.dataview/src/org/netbeans/modules/db/dataview/output/DataViewTableUI.java
+++ b/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();